Excel & DataTables in Power Automate Desktop - Including VBA and VBScript

Video Description

Learn how to use Excel in Power Automate Desktop, including VBA and VBScript. Follow along as we prepare data, perform Excel calculations, and use dynamic file naming. Discover how to easily incorporate VBA and VBScript into your workflows for more efficient automation. 📂 Course Page: https://andersjensen.org/microsoft-power-automate-desktop/excel-datatables-and-vba-vbscript VIDEOS FOR YOU: 🔹 Advanced Excel in Power Automate Desktop: https://youtu.be/ZvbnuQp7x5g 🔹 Save Web Data to Excel with Power Automate Desktop: https://youtu.be/7R5EjshDoQU POWER AUTOMATE DESKTOP GROUPS: 👨‍👩‍👧‍👦 Discord: https://discord.gg/iloveautomation - Join my network with 6000+ Automation/RPA developers, where we solve Automation/RPA problems, network and help each other upgrade our careers. It's free! 👩🏻‍🎓 LinkedIn: https://www.linkedin.com/groups/12566435 👨🏻‍💻 Facebook: https://www.facebook.com/groups/754059285247921 FOLLOW ME: 💼 LinkedIn: https://www.linkedin.com/in/andersjensenorg 📸 Instagram: https://www.instagram.com/andersjensenorg 👨 Facebook: https://www.facebook.com/andersjensenorg 🐦 Twitter: https://twitter.com/andersjensenorg 💌 Email Newsletter: https://andersjensen.org/email-newsletter 00:00 Intro We do Excel calculations in a range of data with Microsoft Power Automate Desktop. 00:41 Prepare Data Download the Excel data from the course page. Then, place it inside the project folder. 02:38 Read Excel Data Launch an Excel instance and remember to close it again; otherwise, Power Automate Desktop can and will lock the Excel book. 9:37 Excel Calculations Use the Insert column to Excel worksheet to insert a column between two existing columns. With a For each action, we loop the data and do Excel operations. Remember to convert the text to numbers before you can do mathematical operations on them. With the Resize columns/rows in Excel worksheet action Power Automate Desktop lets you resize a range of Excel columns. 23:53 Dynamic File Naming We use the date and time of the flow runtime for dynamic file naming. 26:10 VBA We can easily use VBA in Power Automate Desktop with the Run Excel macro action. 31:01 VBScript VBScript, Visual Basic Script, is smarter than VBA, Visual Basic since it's not dependent on running in an Excel book. VBScript and VBA are very similar. #powerautomate #powerplatform #microsoft365