VBA Script not working when calling from Alteryx Designer & Alteryx Gallery.

[vaibhav3339]

Hi Team,

Could you please assist me on how fix this issue where I have created the VBA script which is calling the Excel macro. Both script and macro are present on the Business Shared drive location. I have executed the VBA script manually it's working as expected. But when I am calling the VBA script from Alteryx using command tool. The flow executes successfully but VBA script is not getting trigger. 

My Alteryx workflow has only command tool in which

Command : cscript.exe

Command Argument : Business shared drive location where VBA script is located.

Read Results: Same path as above with file extension as .csv

Note: Alteryx already have access to business shared drive locations.

Please assist me what changes would be required to run the VBA script from Alteryx Designer & Alteryx Gallery.

[binu_acs]

@vaibhav3339 Can you save the VB script and VBA macro locally and try to call from Alteryx to check whether it is working of not?

[dreldrel]

You could try removing the .exe extension from your command and see if that works. For futher details, you can refer to this article, which gives a simple example

https://knowledge.alteryx.com/index/s/article/Alteryx-Run-Command-Executing-Excel-Macros-VBA-1583461...

[vaibhav3339]

I am able to run it from Alteryx Designer but not from gallery.

[vaibhav3339]

I removed the .exe extension but no luck. Though now it's working from Alteryx Designer because I updated some security restriction from Macro but still it's not working from Alteryx Gallery. If you have any other suggestion please do let me know.

[MinhLO]

@vaibhav3339 

If we step back => it's working from Designer meaning your logic is correct.

Hence it's a server related issue:
- On the server, do you have the same access and access rights than on your Designer?

- Did you apply the same security restrictions you did within you Designer on the server?

If it does not work, do you have a log message?