Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Shell function | Excel Programming | |||
Shell function II | Excel Programming | |||
Shell function II | Excel Programming | |||
Shell function | Excel Programming | |||
use shell function in vbscript | Excel Programming |