View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
CraigKer CraigKer is offline
external usenet poster
 
Posts: 8
Default Call .BAT file with paramaters using Excel

I want to call a .bat file with parameters using MS Excel. I tried both the
Shell command and Hyperlink but neither one will work when I try to pass
paramaters to the .bat file. For example if I use the following shell
command without parameters it works:

dim reset
reset = shell( "c:\reset-code.bat",1)

However, when I add my 4 parameters it does not work:
reset = shell("c:\reset-code.bat 2009 2008 Y:\account 19",1)

Has anyone run into this one?

Thanks in advance!!