Calling all Racers for the Alteryx Grand Prix! It's time to rev your engines and race to the stage at Inspire! Sign up here.

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer and Intelligence Suite.

Call VBA macro from Alteryx

sscy
5 - Atom

Hi all,

 

I have a problem, which I hope you guys can help me :)

 

We use a VBA macro to update a number of SAP BO queries and saves them as text files (for an SQL DB). Alteryx does not seem to have access rights to update a SAP BO query directly, but we can update the queries using excel VBA which uses our windows credentials.

 

My questions is: is it possible to call an VBA macro through Alteryx ?

 

We have an Alteryx server, so we could fully-automate our data load, currently someone has to press a button every day and is not able to use Excel when the files are updating.   

 

I look forward to your answer.

 

Br,

Simon

50 REPLIES 50
CokeLuke
8 - Asteroid

Yes 

 

CokeLuke_0-1613944725627.pngCokeLuke_1-1613944760717.png

 

Labels