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

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

lala — Fri, 09 Jun 2023 16:59:34 GMT

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!

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

jthi — Thu, 19 May 2022 10:54:01 GMT

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?

lala — Thu, 19 May 2022 13:58:59 GMT

Thanks jthi!

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

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

lala — Thu, 19 May 2022 11:04:05 GMT

I understand that VBA is still different from VB.

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

jthi — Thu, 19 May 2022 11:12:56 GMT

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.