execute .acsup script from VBA macro
Good Morning Guys! and Thank You in advance for your help. Here's my
question: I have a macro that runs through a list of .txt files created from a avaya cms script. What i would like to do is to only have to run the macro and have the macro run the script then run through the data instead of having to first run the script and THEN run the macro. I've found that just double-clicking on the script will allow it to run without any issue, so i don't need to specifically run it via the cms menus. How can i execute a file (like double clicking on it) via VBA? |
execute .acsup script from VBA macro
See Shell Function in VBA help.
Gord Dibben Microsoft Excel MVP On Thu, 15 Sep 2011 11:53:41 -0700 (PDT), Matthew Dyer wrote: Good Morning Guys! and Thank You in advance for your help. Here's my question: I have a macro that runs through a list of .txt files created from a avaya cms script. What i would like to do is to only have to run the macro and have the macro run the script then run through the data instead of having to first run the script and THEN run the macro. I've found that just double-clicking on the script will allow it to run without any issue, so i don't need to specifically run it via the cms menus. How can i execute a file (like double clicking on it) via VBA? |
execute .acsup script from VBA macro
On Sep 15, 1:21*pm, Gord wrote:
See Shell Function in VBA help. Gord Dibben * *Microsoft Excel MVP On Thu, 15 Sep 2011 11:53:41 -0700 (PDT), Matthew Dyer wrote: Good Morning Guys! and Thank You in advance for your help. Here's my question: I have a macro that runs through a list of .txt files created from a avaya cms script. What i would like to do is to only have to run the macro and have the macro run the script then run through the data instead of having to first run the script and THEN run the macro. I've found that just double-clicking on the script will allow it to run without any issue, so i don't need to specifically run it via the cms menus. How can i execute a file (like double clicking on it) via VBA?- Hide quoted text - - Show quoted text - Got it! it took some extra steps though. I had to create a batch file that pointed to my cms script and call the batch file with the shell function instead of calling the cms script directly. I have another question though and hope you can provide some direction. The CMS Script is coded in VB Script, and of course my macro is coded in VBA. There are similar variables that I would use in both the macro and in the cms script. If I declare these as public in the Macro, would they be accessable in the CMS Script? Vice Versa? |
All times are GMT +1. The time now is 06:16 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com