Shell Function - Syntax
 

Hi All,

VBA Shell() - Excel 2000

I am trying to use Shell() to execute a DOS command but keep getting a "File
Not Found" (Run-Time Error 53) error.

Following is a simple example. What am I doing wrong? Thanks.

Dim MyID as Integer
MyID = Shell("Format A:")

bill m

Shell Function - Syntax
 

ID = Shell("command.com /c format a:")

but you will still have to communicate with the format program
--
Gary''s Student


"bill_morgan" wrote:

Hi All,

VBA Shell() - Excel 2000

I am trying to use Shell() to execute a DOS command but keep getting a "File
Not Found" (Run-Time Error 53) error.

Following is a simple example. What am I doing wrong? Thanks.

Dim MyID as Integer
MyID = Shell("Format A:")

bill m

Shell Function - Syntax
 

Work perfectly. Thank you ...

"Gary''s Student" wrote:

ID = Shell("command.com /c format a:")

but you will still have to communicate with the format program
--
Gary''s Student


"bill_morgan" wrote:

Hi All,

VBA Shell() - Excel 2000

I am trying to use Shell() to execute a DOS command but keep getting a "File
Not Found" (Run-Time Error 53) error.

Following is a simple example. What am I doing wrong? Thanks.

Dim MyID as Integer
MyID = Shell("Format A:")

bill m