All Activity

MAP – REDUCE – SCAN MAKEARRAY –BYROW – BYCOL ISOMITTED These are recently announced functions by Microsoft .where we can pass lambdas as arguments Download template files

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.

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.

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

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

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

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.

Google Spreadsheets vs. Microsoft Excel: What Should You Choose & when ?

It will be our pleasure to help you and see you growing in your professional journey

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.

program done. It was nice.

Download Excel file

seen entire video.

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. ?

fantastic. looking forward to learn more.

Done filling names in highlighted cell. It was interesting.

The output cell is I10