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

Question

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 Answer

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