How to run VBA Code in Alteryx

[sameerjha28]

Hi,

I have a VBA code which is downloading data from sharepoint and saving them in excel sheet 1.

I need to run this code from Alteryx and use the generated excel output as a Input Source.

I am not getting any idea how to run this VBA code in Altryx. Run Command is not serving my purpose here.

[sameerjha28 · Accepted solution]

This is nicely answered in below post.

https://community.alteryx.com/t5/Alteryx-Connect-Gallery/Call-VBA-macro-from-Alteryx/m-p/46228/highl...