Compiling Code Dependent on External Files

The script I am trying to compile modifies existing external files (i.e. Excel files). When I compile the script and add the external files to "Files required for your application to run," how are these files stored in the compiled program? The reason I am asking is that these external files reference each other based on location, so the script wouldn't work if their relative locations change in the compilation.

The obvious alternative is to distribute the compiled script and the external files as separate attachments, and then use uigetfile to have the user retrieve them manually, but this is less convenient.

Answer 1

[Robert Cumming]

if i recall the files will be extracted into the same directory as your exe - so you could work the relative paths from that scenario.

[Kevin]

Hmm. The directory does not seem to contain any of the "required" files.

[Robert Cumming]

did you add the files in the "Files required for your application to run" or the section "Files installed with you application"?

Adding the files to the 2nd option should result in the files being located in the same dir as your exe.

[Kevin]

So I added the files to both "Files required" and "Files installed". I have the script associated with the .exe reference the external file assuming they are in the same directory.

But when I run the .exe, it appears the script is located in some obscure "...\AppData\Local\Temp\..." folder. Any way I can get a handle on this?