shell to open external bat file

**zhuleijia** · 04-06-2013, 10:45 PM

Dear all,

i was trying to run a bat file from excel macro using shell()
while i was able to find and run bat file, the bat file thinks it is in Libraries\Documents, instead of the folder the bat file is actually in, is there anyway to fix this?

this is my macro
'Location = Range("A8") + "\asdf.bat"
'task = Shell(Location, 1)

thanks in advance
Best regard

**protonLeah** · 04-06-2013, 11:49 PM

Put a line at the top of the batfile to change to the desired directory:

cd C:\WINDOWS\desired folder...

**zhuleijia** · 04-07-2013, 12:02 AM

thank you for replying, but i m afraid cd wont fix the problem because the location the batfile uses is not always the same, it is based of the value in cell A8. which is the current location of the bat file

**protonLeah** · 04-07-2013, 12:28 AM

Are you saying the the batfile itself is changing locations? Can you can edit the batfile to take parameters from the command line?
For instance use %1 to capture the command line:

Location = Range("A8") + "\asdf.bat " & Location
task = Shell(Location, 1)

Then asdf.bat would read Location into parameter variable %1
and cd %1 would change to Location