Question for Kim Anderson or anybody else..........

[Guest.Visitor]

Hi, I previously had a client access question today in which Kim Anderson answered very well. I also need to call a .BAT program from an Excel macro to run my tranfer requests. How is this done ? Can you please give me an example ? Thank you again !! Jim Sovick jim.sovick@jostens.com Class rings, Superbowl rings, NBA Championship rings, etc...

[Guest.Visitor]

This is how I do it. There may be other ways. RmtCmd = "c:forecastfcst2pc.bat " Result = Shell(RmtCmd, vbNormalFocus) I prefer the vbNormalFocus because it opens a new window for the operation and makes it easier to monitor if there are problems.