Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can't run batch file from macro or shell

Status
Not open for further replies.

MCSGraham

Programmer
May 28, 2002
52
US
I don't understand this one at all.

I have a program on a person's computer where I do a 'runapp' with a macro to execute a batch file under the person's C drive. It doesn't run the batch file doing this.

The batch file does work because I manually clicked it and it runs fine.

I've also tried using the 'shell' and the batch file's path to execute it and that doesn't work either.

But I've tried running the program on my computer with the same batch file under my C drive and it works.

I can't believe it's a permissions issue cause she's running the program from her computer and the batch file is on her computer too.

Does anyone have any suggestions?
 
Not really any code just this:

In Access: Docmd.RunMacro("reformat file")

(The macro is 'runapp' with the command line of: c:\reformat.bat)

Batch file:

cd ..
copy c:\iecon.txt g:\ie.txt
exit

Any suggestions?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top