| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
OPen one Spreadsheet from another
I have a series of spreadsheets that I am currently running manually each
morning. For reasons I won't get into here I can't use scheduler so what I am looking to do is the following Open the first spreadsheet have it do its thing, then open the next one in the sequence and close off the first. What is the best way of doing this |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
OPen one Spreadsheet from another
You could use this sort of construct Sub Auto_open() Workbooks.Open ("Book1.xls") ThisWorkbook.Saved = True ThisWorkbook.Close End Sub -- mrice Research Scientist with many years of spreadsheet development experience ------------------------------------------------------------------------ mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931 View this thread: http://www.excelforum.com/showthread...hreadid=550328 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a way to force a pop up when spreadsheet is open? | Excel Discussion (Misc queries) | |||
| How can I open an OpenOffice spreadsheet in Excel? | Excel Discussion (Misc queries) | |||
| #NAME when I open up my spreadsheet | Excel Worksheet Functions | |||
| Why doesn't the spreadsheet file open. | Excel Discussion (Misc queries) | |||
| Cannot open a shared excel spreadsheet | Excel Discussion (Misc queries) | |||
Hybrid Mode
