How to run VBA Code in Alteryx

Question

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 Answer

This is nicely answered in below post.

https://community.alteryx.com/t5/Alteryx-Connect-Gallery/Call-VBA-macro-from-Alteryx/m-p/46228/highlight/false#M1511