Alteryx Run command- VBA

[ShreyaSharma]

Hi Team,

Is there any pre set command in Alteryx like VBA code to format the Output data if not then how to write the code in Alteryx .

[Emil_Kos]

Hi @ShreyaSharma,

For my best knowledge no.

This is a post that has an example of using vba with Alteryx.

[ShreyaSharma]

Hi @Emil_Kos 

One question I have ...

My output excel file size is 40 MB ... containing 7 tabs .

Now, I implemented the reporting functionality to get the output in more presentable format but the disadvantage i could see is it take too much time to get the output. Also the file size turn to 300 MB .

Is there a way to reduce the size of the output file using when we use the reporting tool like render to get the output in more format manner.

Thanks for your help

[Emil_Kos]

Hi @ShreyaSharma,

This post might be helpful:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/render-tool-extremely-slow/m-p/41259/h...

[Subh]

Hi, please check out the link below:

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Alteryx-Run-Command-Executing-Excel...

[Qiu]

@ShreyaSharma 
I made this sample before for alling VBA in alteryx.

It should give a start on how to to use it.

[Subh]

Hi Qiu, Attachment is corrupt. Can you please reload it?

[Qiu]

@Subh 
I took it out of a bigger flow, and I think they are some dependencies there.
Just ignore the pop up error and I just tested.

[Subh]

@Qiu - I have modified the codes and input source for Essbase retrieval (aslo added as Boolean in VB) but did not work out.