Shell Loading .exe; No Result Generated.

shawkins13

New Member
Joined
Jul 30, 2010
Messages
5
I have a macro that changes a few text lines in a file called LREAD. It then calls an executable that uses LREAD to generate an output file called LWRITE.

Many files have to be analyzed by the executable so I have set this up to run by itself and copy LWRITE files over to another drive.

This macro was working perfectly yesterday. Today I go to load it and when I call the shell function, the executable runs, but no new LWRITE file is generated. However, if I run the executable by itself (without the macro), then the LWRITE file is generated correctly. Therefore the error somehow rests with the shell command and not the .exe itself. HELP!

What is going on here??? Why would my code be working one day and suddenly stop working the next? :confused: :( :confused: :(
 

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.
For future reference:

There was a problem with the call to certain directory on my computer. This messed up the executable because output files were placed in the wrong drive.

To fully change a path, you have to change the drive first and then change the directory. For example to change from C:\Documents to P:\MyFolder, both of the following are needed in the code:

ChDrive "P"
ChDir "P:\MyFolder"

:biggrin: finally.
 
Upvote 0

Forum statistics

Threads
1,224,574
Messages
6,179,626
Members
452,933
Latest member
patv

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top