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!!

This worked for me:

Sub RuntestProgram()
Dim program As String
program = "C:\Delete\test.bat fred"
TaskID = Shell(program)
End Sub


where test.bat was simply

copy C:\Delete\text.txt C:\Delete\%1.txt

It created the file fred.txt, a copy of text.txt

--
HTH,
Bernie
MS Excel MVP


"CraigKer" <(E-Mail Removed)> wrote in message
news:C9BC5A1A-C666-483D-AB2F-(E-Mail Removed)...
>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!!

Hi Craig

You code is fine.

Please check your .bat file for (4 parameters, path mentioned, file
extension mentioned etc; ) If you cannot find an issue paste your code and we
will have a look at it

If this post helps click Yes
--------------
Jacob Skaria


"CraigKer" wrote:

> 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!!