Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Running a batch file from Excel VBA
Hello
My macro creates text files that, subsequently, I would like to automatically run the batch file which saves them to a remote location (ftp). Is it possible for VBA to run an outside program? W |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Running a batch file from Excel VBA
On Sun, 20 Jul 2003 08:02:49 GMT, "verizon"
wrote: Hello My macro creates text files that, subsequently, I would like to automatically run the batch file which saves them to a remote location (ftp). Is it possible for VBA to run an outside program? Yes. See on-line help for the Shell function, a summary of which is below: -------------------------------- Shell Function Runs an executable program and returns a Variant (Double) representing the program's task ID if successful, otherwise it returns zero. Syntax Shell(pathname[,windowstyle]) --------------------------------- --------------------------------------------------------- Hank Scorpio scorpionet who hates spam is at iprimus.com.au (You know what to do.) * Please keep all replies in this Newsgroup. Thanks! * |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can excel run a batch file? | Excel Discussion (Misc queries) | |||
Excel from Batch File Problem | Excel Discussion (Misc queries) | |||
Excel to Run a Batch File?!? | New Users to Excel | |||
Hide Excel session when running at the batch mode | Excel Discussion (Misc queries) | |||
Call a batch file from an Excel Macro | Excel Discussion (Misc queries) |