My tasks.robot is creating an Excel file during its execution, let’s call it Excel99.xlsx :
I want to re-design the header (apply header filters, change color etc) and replace text of entries inside of this new Excel99.xlsx.
To do this I’m looking to run an Excel macro or the corresponding VBS script.
My question is: how can i run a macro that is stored on another MacroExcel.xlsm file on the same folder of Excel99.xlsx ? Alternatively how can i directly run the VBS script so that it applies to Excel99.xlsx?
If i should just resort to python let me know, i’m open to any ideas.