View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
cogent cogent is offline
external usenet poster
 
Posts: 32
Default Simple Shell Commands

Hello

Quick help, please.

In the following command:

Shell "command.com /c" & _
"copy c:\dest.txt+c:\source.txt c:\dest.txt /b"

what does the Shell "command.com /c" accomplish?

I am running shell commands that I want to make sure are executed with the
active path at the prompt so that the commands behind it are able to be
effected on a RELATIVE basis. How?

Like this:?

Shell "command.com " activeworkbook.path & _
"copy c:\dest.txt+c:\source.txt c:\dest.txt /b"

The macro is run in a thumb drive where the drive number may vary, but the
shell commands must be executed in the directory on the thumb drive.

Please help.

W