Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Why 39 sec. delay for simple commands, Excel 2003? Thanks! fmes Excel Discussion (Misc queries) 1 December 19th 09 02:10 PM
Shell command MAx Excel Programming 2 June 4th 04 04:11 PM
Commands at the line prompt using Shell cogent Excel Programming 2 April 27th 04 04:56 AM
Shell Joseph[_12_] Excel Programming 1 February 1st 04 04:33 AM
Shell Statement Confused@424 Excel Programming 1 August 13th 03 08:19 PM


All times are GMT +1. The time now is 08:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"