View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
R Tanner R Tanner is offline
external usenet poster
 
Posts: 87
Default Running A Shell Command In VBA

Hi,

I'm trying to run the following shell command in VBA but it is telling
me the file is not found. My home directory when I bring up the
command prompt manually is C:\Documents and settings\robin.grossman,
which I think is the problem. What should I do?

Shell Environ$("COMSPEC") & "DEL Z:\Client Services\Operations
\PrintedVersion.pdf"