Here's my problem:
I am creating a drop down list by searching through several folders for any macros that are stored there. The macros are stored in an array and then presented via a dropdown list. The user then picks one of the macros from the list.
I then take the name of the macro that was selected and use the Shell command to run the macro:
Code:
macroname = "ebrun.exe " + Filenames(FileChosen)
rc& = Shell (macroname,4)
The problem is that I can't use $Include in the macros that are run via the Shell command. I want to include a header file that contains global variables. If I add the Include, the macro doesn't run. Without the Include, it works fine.
Anyone know why this is, or how I can run the macro without using the Shell command?
I am creating a drop down list by searching through several folders for any macros that are stored there. The macros are stored in an array and then presented via a dropdown list. The user then picks one of the macros from the list.
I then take the name of the macro that was selected and use the Shell command to run the macro:
Code:
macroname = "ebrun.exe " + Filenames(FileChosen)
rc& = Shell (macroname,4)
The problem is that I can't use $Include in the macros that are run via the Shell command. I want to include a header file that contains global variables. If I add the Include, the macro doesn't run. Without the Include, it works fine.
Anyone know why this is, or how I can run the macro without using the Shell command?