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 ".
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!
Automation and ScriptingData AccessWindowsRe: 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.
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
Re: How do I open Excel in JSL to run the specified VBA?I understand that VBA is still different from VB.
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.
