Advent of Code is now back for a limited time only! Complete as many challenges as you can to earn those badges you may have missed in December. Learn more about how to participate here!
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

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

Running Excel Macro VBA Script through Run Command

HarishKhanna1
7 - Meteor
‎03-25-2024 03:16 AM

Can anyone share a sample workflow using Run command tool to run the excel macro VBA script (.vbs extension) and .xlsm file 

Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

4 REPLIES 4
danilang
19 - Altair
19 - Altair
‎03-25-2024 09:05 AM

Hi @HarishKhanna1 

 

Try the example in this knowledge base article

 

Dan

Reply
0 Likes
HarishKhanna1
7 - Meteor
‎03-25-2024 10:21 PM

Thanks Dan. If I have to create a new macro within other excel workbook, What should be the configuration of the run command tool (assuming that I have .xlsm file and .vbs file ready) ?
Thanks, In advance..

Reply
0 Likes
Qiu
21 - Polaris
21 - Polaris
‎03-25-2024 10:31 PM

@HarishKhanna1 
I made one sample before. Hope it can help/

 

WeeklyChanllege-Ja-20210309.yxzp
Reply
0 Likes
HarishKhanna1
7 - Meteor
‎03-26-2024 10:44 PM
I am getting below error while I am running the workflow..But .vbs file is externally running using windows without any error..Please help me with the configuration of run command tool here

Capture.PNG

Reply
0 Likes
Christmas in July Blog
designer new user guide
Labels
Top Solution Authors
View All