Jump to content
Business Intelligence & Analytics for Digital Transformation

All Activity

This stream auto-updates

  1. Last week
  2. MAP – REDUCE – SCAN MAKEARRAY –BYROW – BYCOL ISOMITTED These are recently announced functions by Microsoft .where we can pass lambdas as arguments Download template files
  3. Version 1.0.0


    lambda helper finctions MAP Redude Scan Byrow ByCol makearray isomitted
  4. Earlier
  5. As-Salamu Alaikum (Peace be upon you), I am Ashrafu Alam, from Chittagong, Bangladesh. I worked at a steel industries as an Accounts officer. Now I am a lecturer at Kadalpur School and College.
  6. Office has a fresh look. It’s modern and new, designed to help you focus on your best work. This new update includes: Simple, intuitive, and seamless experience across all your Office apps Customizable ribbon that you can change and create shortcuts to everyday commands you use the most Office themes that stays in sync with your Windows light or dark mode setting by default Share your work and collaborate with others in real time by selecting Share and sending your draft to whomever you want.
  7. We will use setValue() to write data in cell This tutorial will tech you 1 Where to write code 2 How to run the program, 3 Writing data in cell using setValue() ----------------- A good hand on example to start your office script journey
  8. Hi team, I am trying to combine two simple excel files just to learn this power query and getting this massage: DataFormat.Error: External table is not in the expected format. Details: cd5hk2xn.XLS can you help please
  9. Hi Sam A delay addon in between each step may be a quick trick to resolve the same Just see how much seconds manually printing take place and then just add delay say of 30 seconds to 1 minutes Hope that helps Regards Saurabh
  10. I am trying to convert different files (Word, Excel) in a folder to PDF files ("interim pdf files") and then merge them into one PDF file. In order to do this, I will select all Word documents, and Excel documents, and run through them in separate loops to convert to interim pdf files via PDF Printer. Take the Word loop as an example: To ensure the same UI window name, I will rename each Word document (currentitem) to ToPrint.docx, and then print ToPrint.docx to PDF Printer, and then populate the "save as" with the original document directory and name followed by ".pdf". The issue I am encountering is: The loop will go through first run ok, but during the 2nd run, I receive an error message that I cannot rename the 2nd file because ToPrint.docx is used by another process. I have also added a wait for 60 seconds just in case the previous process takes longer time. However, I still get the same error. Many thanks.
  11. Google Spreadsheets vs. Microsoft Excel: What Should You Choose & when ?
  12. It will be our pleasure to help you and see you growing in your professional journey
  13. TIBCO Spotfire software is the most complete analytics solution on the market, enabling everyone to explore and visualize new discoveries in data through immersive dashboards and advanced analytics. Spotfire® analytics delivers capabilities at scale, including predictive analytics, geolocation analytics, and streaming analytics. And with Spotfire Mods, you can build tailored analytic apps rapidly, repeatedly, and to scale. It allows users to combine data in a single analysis and get a holistic view of the same with an interactive visualization. Spotfire software makes businesses smart, delivers AI-driven analytics, and makes it easier to plot interactive data on maps. The platform helps businesses transform their data into powerful insights with ease and in less time. It speeds up data analysis across an organization for faster, confident, and much accurate decision-making.
  14. Version 1.0.0


    Download file
  15. Hi I could do the assignment for this tutorial. Converting celsius to Fahrenheit. I tried to add With Range and it gives me error, object require. Pls advise where my code is wrong. Sub celcius() Dim celcius As Integer Dim Farenhiet As Integer celcius = InputBox("Give me temperature in Celcius") Range("B3").Value = celcius Farenhiet = (celcius * 1.8) + 32 With Range("B4").Value = Farenhiet .Font.Size = 11 .Font.Color = "2367" MsgBox "Farenhiet is" & " " & Farenhiet End With End Sub Without using "With" it works. Do I need to use the Worksheets object. ?
  16. Version 1.0.0


    New year Flower roses
    Very nice collection of images. I'm a Realtor here in Los Angeles. I am particularly interested in the Hallstatt, Austria community at the lake, and Neuschwanstein Castle in Bavaria. I'm going to see what I can learn about Both of those. Thanks! All the best, Kieran Jackson
  17. Done filling names in highlighted cell. It was interesting.
  1. Load more activity
  • Who's Online   0 Members, 0 Anonymous, 5 Guests (See full list)

    There are no registered users currently online

  • Member Statistics

    Total Members
    Most Online
    Phyo Phyo
    Newest Member
    Phyo Phyo

  • Create New...