Hi, I was wondering if anyone know if it's possible in pml to somehow make the !variable('D:\OUTPUT.csv') and !variable.WriteFile('Overwrite', !array) commands but with output from two different macros working one after another and saved together into one .csv (or maybe .xls) file but each output into seperate sheet?
If you are writing to a CSV file then it will be a flat file and it will not be able to hold multi-sheet structure which is available in EXCEL so the short answer for CSV is no. However, another possible method would be:
1. Write output to two different CSV files
2. Use Excel macro which will read these CSV files and import data onto two separate tabs.
I have not tried with Excel directly so will not comment on that part.
