View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Denny Denny is offline
external usenet poster
 
Posts: 38
Default Shelling out to DOS

Can I run a batch file before or as I shell out of Excel...or can I change
the directory AND the prompt from VBS. I changed the directory, but can I
add a prompt change. This was my directory change.
ChDir "C:\my documents\"
Shell Environ ("comspec" & " /k ", vb MaximizedFocus