This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.
Can you provide a bit more context about what you're trying to do Ganesh0010?
If you really just want to open a .VBS file into Alteryx as data, you can use an Input Data tool and configure it to open it like you might a .TXT file, by telling Alteryx that it is a delimited text file with no delimiter:
However, I suspect you might be trying to do something else; let me know if this is the case.
If it helps, I usually operate in the reverse. I use Text Input, Formula tool, etc. to create the data for the .VBS file, then I use the Output Data tool to write the .VBS file to disk, before calling it from the "Events" tab.