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.

Developer Tools

Run Command

Accepted answers

BenMoss

I didn’t know there was a community article for this, as posted above, but I blogged this very usecase myself just a couple of weeks ago (formatting).

https://www.theinformationlab.co.uk/2020/04/14/triggering-excel-macros-from-the-comfort-of-your-alteryx-workflow/

Ben

All comments

AbhilashR

Hi @rishabh_1995, the following Community post might be a good starting point for what you are looking to achieve: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Alteryx-Run-Command-Executing-Excel-Macros-VBA/ta-p/471551

BenMoss

I didn’t know there was a community article for this, as posted above, but I blogged this very usecase myself just a couple of weeks ago (formatting).

https://www.theinformationlab.co.uk/2020/04/14/triggering-excel-macros-from-the-comfort-of-your-alteryx-workflow/

Ben

rishabh_1995

Thanks @BenMoss

I've configured the steps based on what's mentioned in the article (see picture below).

But I keep getting the following error message and I'm not sure what to do with it.

I've put the Macro in my personal macro workbook, and have doubled check to confirm that my macros are enabled. Would you happen to know why this error comes.

rishabh_1995

Hi @BenMoss

I had just leveraged the solution you had posted in your article for a different use case, where the entire formatting was done using VBA script. I know it's been a while since I wrote back on the post, but just thought of mentioning this as the solution you gave really helped out with the new situation I had.

Many thanks again !

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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703