I know this is sort of off topic but I have not been able to find a answer anywere I have looked.
I have written a little program called SSTe.exe. When executed it opens a file called SSTe.start that resides in the same folder. In this file is the actual file name with the data needed for the calculations. If the SSTe.exe is started by double clicking it always works (thus far at least ;-)
Since I am not going to be the only person working with the program I wanted to make the generation of the input data a little more convenient. To that end I have created a Excel file that contains all the data and creates the needed input file and changes SSTe.start accordingly. So far this all works fine and I can MANUALLY execute the SSTe.exe with no problem.
I would however like that the macro used to generate these files also starts the simulation. To that end I have found the following VBA command that works sort of fine:
Dim relativePath As String
relativePath = ThisWorkbook.Path
SSTe = Shell(relativePath & "\SSTe.exe", vbNormalFocus)
In any case SSTe.exe starts but then fails to open SSTe.start. For some, even stranger reasons, it did work for about an hour last night, but this morning that was history.
Do you have any suggestions what could be the problem?
Thanks for any comments, hint, suggestion or, best of all, solutions
The SSTe.exe looks for the SSTe.start in the same directory as it resides itself.