cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Check out the JMP® Marketplace featured Capability Explorer add-in
Choose Language Hide Translation Bar
lala
Level VIII

How do I open Excel in JSL to run the specified VBA?

Hello!
How do I open Excel in JSL to run the specified VBA?For example, run "sub tt()" in "C:\1\ book1.xlsm ".

 

 

2022-05-19_18-42-36.png
This question has been raised in the community but has not been answered.
Of course, this screenshot is just a hint.This is not how the VBA is implemented.Thank you very much!

4 REPLIES 4
jthi
Super User

Re: How do I open Excel in JSL to run the specified VBA?

I think you should be able to use Run Program() to do this.

-Jarmo
lala
Level VIII

Re: How do I open Excel in JSL to run the specified VBA?

Thanks jthi!

I searched for this post. But I still don't know how to code JSL. Run VBA code in JSL script 

lala
Level VIII

Re: How do I open Excel in JSL to run the specified VBA?

I understand that VBA is still different from VB.

jthi
Super User

Re: How do I open Excel in JSL to run the specified VBA?

You could look for how to use for example Powershell to execute macro in excel file. And then user Powershell through JMP's Run Command. This might work depending what you are trying to do.

-Jarmo