Hi there, this is my first post, hope I don’t confuse everyone too much with my problem.
I am trying to iterate through each excel file in a folder, read a cell value from an excel file and then rename that workbook using that value.
So far I have.
Assign: Variable1 using System.IO.Directory.GetFiles(PathVariable)
ForEach file in Variable1
Set Excel Application Scope to file
Read Cell and Set Variable2
Assign Variable3 = left(Variable2, 5) since i only need the first 5 characters
and then rename file by using
Move From: PathVariable To: Variable3
I’m running out of ideas to attempt. Hope you awesome bot-makers can assist.