Creating multiple PDFs based on a list is a common use case in Excel. I’m asked about it regularly. A few weeks ago, I received this question about our Office Scripts course: Before I start the course on Office Scripts, I was wondering if it is possible to loop through a spreadsheet and with each … Read more
Power Automate Desktop is a Microsoft tool for automating processes in a desktop environment. It’s a really powerful tool, but suffers from one significant drawback… it has limited Excel actions. However, Microsoft has given us the ability to run Excel macros from Power Automate Desktop; therefore, this gives us the power to do almost anything … Read more
It is common in many businesses to send regular email summaries or reports to senior executives. Typical scenarios include daily sales reports or cash-flow positions. These emails often contain images displaying the key information. With the current cloud technologies, we now have an easy way to automate this. So, in this post, we look at … Read more
For a long time, I’ve been asking Microsoft for the ability to run a Power Automate flow from an Office Script. Office Scripts are restricted to operate only on objects within the workbook. Therefore, we can’t currently run a script that changes another workbook, or undertakes other activities outside of Excel. This significantly reduces the … Read more
CSV files are a common file format; they are regularly used to export data from IT systems. Excel desktop can convert CSV to Excel with ease. However, in the online world of Office 365, things aren’t quite so simple. The online world provides us with new automation opportunities not available in a desktop environment. However, … Read more
In this post, we are covering how to sort sheets alphabetically using Office Scripts. Actually, the final code will be flexible enough to sort sheets in many different ways. I’ll share the basic script, along with the steps to create a more dynamic and robust solution. By the end, we will have a script that … Read more
In this post, we are looking at how to use Office Scripts with Power Automate. They are both relatively new tools in the online world, and when used together, they create a new ecosystem for automation with Excel. Power Automate is a cloud-based low-code / no-code tool that enables automation through connectors into many Microsoft … Read more