Running VBA Script in workflow

[rishabh_1995]

Hi Alteryx Community,

I'm trying to run a very simple VBA script in Alteryx to do some very basic formatting on the output Excel file I generate (which is simply to fix certain column widths & row heights). I'm rendering the output Excel file using the Reporting tools. Just wanted to understand how I can configure my workflow to run the VBA Script inside Alteryx itself rather than having to run it after opening the Excel file (I've saved the script in an xlam file).

I do know that probably the run command tool would do the trick, but I'm really not sure how to get that configured properly. Would be keen to know if someone could help me with that.

[Bushra_Akhtar]

Hi @BenMoss,

I have just stumbled across your article.  I have 85 spreadsheet I need to apply conditional Formatting rules to so to go into every spreadsheet file and write a Macro/ Script is very time consuming.  Is there a way to replicate this so that the entire code is run from Alteryx itself or have another workaround?

Many Thanks

B

[CJaekl]

Try having the workbook with the macro open before running the workflow.