help creating an EXE

[bhogue]

I have three macros. The first uses Notepad. The second uses MS Access. The third call the other two macros. I want to give my use an EXE. I created an EXE from the third macro. It failed to find the first macro. This is understandable since it was looking in the wrong directory. More importantly, I expected the EXE to convert all three macros. I suspect that is not how the product works. If my suspicion is correct, I see two solutions. One, I put all the code into one macro and make an EXE of that combined macro. Two, I make EXEs of the first two macros, change the third macro to call those EXEs and finally make an EXE of the revised third macro.

Are there any other choices? What is the recommended solution?

-brian

[support]

You have three options:

1. Put all the code in one script and compile that to one .exe

2. Compile three separate .exes and have one call the others using Run command.

3. Compile only one and have it call the other .scp files using Macro command.

You're unlikely to want to do three as it exposes the script code for the two other macros. So the choice really is between one and two and depends how important code re-use is to you. There are advantages having separate exes if you want to have the option of running them independently and don't want to duplicate code. But one is slightly easier to distribute and install. It all depends on what suits you best.