Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
I have multiple excel files I wish to open in sequence. They all have auto_open() macros so they update, save and close. My problem is that when I put them in a batch file, all my excel files open at the same time. Any idea? P.S.1 Calling different batch files from a main batch does not work. The only thing the underlying batch has to do is start excel and when it does, its job is done and the main batch goes on to the next command. P.S.2 I thought about delaying the second job with PING 1.1.1.1 -n 1 -w 60000 NUL but I'd have to know how long each of my files takes to update |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Batch file initiation from Excel macro? | Excel Discussion (Misc queries) | |||
Call a batch file from an Excel Macro | Excel Discussion (Misc queries) | |||
Call a batch file from an Excel Macro | Excel Discussion (Misc queries) | |||
Run Excel Macro in a Batch File | Excel Programming | |||
VBA Code needed to start different public sub | Excel Programming |