Thread
:
SHELL command
View Single Post
#
2
Posted to microsoft.public.excel.programming
Chip Pearson
external usenet poster
Posts: 7,247
SHELL command
Robin,
Put the DOS Dir command in a bat file and call that bat file from Shell.
E.g,
Shell "C:\Test.bat",1
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"Robin Clay" wrote in message
...
Greetings !
Regarding -
Shell "dir C:\ /S C:\DirList1.$$$",1
..which works just FINE in a DOS window, but not in
VB
[RunTime error 53: File not found]
Can SKS please suggest -
(a) why it doesn't work
(b) what it should be, in order to work; and/or
(c) a better way of achieving the same thing?
RClay AT haswell DOT com
Reply With Quote
Chip Pearson
View Public Profile
Find all posts by Chip Pearson