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

Question

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.

MinhLO · Answer

@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?

vaibhav3339 · Answer

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.

vaibhav3339 · Answer

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