View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
John.Greenan John.Greenan is offline
external usenet poster
 
Posts: 175
Default Shell Function - Execute DOS Command

Can I suggest binning the use of shell? have a look at this link:

http://msdn.microsoft.com/library/de...ctPropMeth.asp

It's the Windows Script Host. It's much more user friendly that running
shell (la la la).


--
www.alignment-systems.com


"bill_morgan" wrote:

Excel 2000 running in XP:

Having trouble getting consistent results from VBA Shell Function.

For example, this command appears to run okay, but doesn't print cat.txt,
which is located in root directory. Is there something wrong with syntax?
Thanks ....

ID = Shell("command.com /c print cat.txt")

bill morgan