Run Command Tool to get Excel VBA macro to format a workbook

[Aaron_Bowen]

Hi, 

I've been trying to configure the Run Command Tool to run an Excel VBA macro that formats the workbook (i.e. freezes the header row, justifies all of the text left, autofits column width, adds filters, changes the font, etc.). The issue is that the Run Command Tool creates a new Excel export, so it overwrites the file that I formatted. Any help would be greatly appreciated. 

Thanks, 

Aaron 

[ArnaldoSandoval · Accepted solution]

Hi @Aaron_Bowen 

Please, take a look at my reply to Locking columns in excel output ; just replace the macro to apply the Excel formatting and you are in business.

hth

Arnaldo