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.

Video