In this course, you'll learn Microsoft Power Automate Desktop from the beginning. We use a modified real-life example, so this will not be boring 😀
VB Script
Here's the VBScript code we use in the video - you can copy/paste.
' Initialize Excel
Set objExcel = CreateObject("Excel.Application")
' Open the Excel file
Set objWorkbook = objExcel.Workbooks.Open("ExcelBookPath")
' Loop through each sheet in the Excel book
For Each objWorksheet In objWorkbook.Worksheets
objWorksheet.Activate
' Get the used range in the worksheet
Set objRange = objWorksheet.UsedRange
' Loop through each cell in the used range
For Each objCell In objRange
' Replace all instances of '£' with an empty string
objCell.Value = Replace(objCell.Value, "£", "")
Next
Next
' Save the changes to the Excel file
objWorkbook.Save
' Close the Excel file
objWorkbook.Close
' Quit the Excel application
objExcel.Quit Resources
Network and solve Power Automate Desktop problems with more than 5600 RPA Developers: I Love Automation discord.
You're welcome to connect with me on LinkedIn: Anders Jensen (and please send me a message if you like this course).
My always-updated Excel sheet with the best Microsoft Power Automate Desktop resources: Power Automate Desktop Resources.xlsx.
