Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
batch file to open multiple worksheets
I would like to run a batch file to open multiple Excel worksheets but if I
put the path to both sheets, it only opens the first one. What am I doing wrong? I'm using Excel 2003 SP-1 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
batch file to open multiple worksheets
I should also add that once I close Excel, then the second worksheet opens.
"Kurt S" wrote: I would like to run a batch file to open multiple Excel worksheets but if I put the path to both sheets, it only opens the first one. What am I doing wrong? I'm using Excel 2003 SP-1 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
batch file to open multiple worksheets
Use start rather than just running them:
c: cd\ start poly.xls start qwerty.xls exit If you just run them, the bat file hangs until you finish the first application and then runs the second application. "starting" something allows no waiting -- Gary's Student "Kurt S" wrote: I should also add that once I close Excel, then the second worksheet opens. "Kurt S" wrote: I would like to run a batch file to open multiple Excel worksheets but if I put the path to both sheets, it only opens the first one. What am I doing wrong? I'm using Excel 2003 SP-1 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
batch file to open multiple worksheets
That did the trick. Thank you Gary.
"Gary''s Student" wrote: Use start rather than just running them: c: cd\ start poly.xls start qwerty.xls exit If you just run them, the bat file hangs until you finish the first application and then runs the second application. "starting" something allows no waiting -- Gary's Student "Kurt S" wrote: I should also add that once I close Excel, then the second worksheet opens. "Kurt S" wrote: I would like to run a batch file to open multiple Excel worksheets but if I put the path to both sheets, it only opens the first one. What am I doing wrong? I'm using Excel 2003 SP-1 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
batch file to open multiple worksheets
You are very welcome.
b.t.w. if you do a lot of bat files, you should checkout Windows Scripting Host. It's just as much fun as DOS 6.22 -- Gary's Student "Kurt S" wrote: That did the trick. Thank you Gary. "Gary''s Student" wrote: Use start rather than just running them: c: cd\ start poly.xls start qwerty.xls exit If you just run them, the bat file hangs until you finish the first application and then runs the second application. "starting" something allows no waiting -- Gary's Student "Kurt S" wrote: I should also add that once I close Excel, then the second worksheet opens. "Kurt S" wrote: I would like to run a batch file to open multiple Excel worksheets but if I put the path to both sheets, it only opens the first one. What am I doing wrong? I'm using Excel 2003 SP-1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Saved *.csv file gives SYLK file type warning upon Excel 2003 open | Excel Discussion (Misc queries) | |||
Trying to open file, may have renamed it | Excel Discussion (Misc queries) | |||
Excel startup switches | Excel Discussion (Misc queries) | |||
hidden rows & columns slow file open | Excel Discussion (Misc queries) | |||
Sumif Linking to Another Workbook error #VALUE! | Excel Discussion (Misc queries) |