Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Question about opening workbooks on Excel startup
Windows XP Pro
Excel 2002 I would like to open particular workbook every time Excel starts, similar to how PERSONAL.XLS opens when I start Excel. As a test I saved a workbook in the same folder as the PERSONAL.XLS file, and sure enough it opened also with Excel. However, I would like this workbook, call it TestBook, to open up hidden like PERSONAL.XLS does, and I'd still like Excel to open a new workbook Book1.xls every time Excel starts. Is this possible? If so, how? Thanks! -gk- -- ================================================== ====================== "The creative act is not the province of remote oracles or rarefied geniuses but a transparent process that is open to everyone." -Greg Kot in Wilco Learning How To Die- |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Question about opening workbooks on Excel startup
Open TestBook and hide it using Window | Hide. Be sure to save it when
prompted. -- Vasant "38N90W" wrote in message ... Windows XP Pro Excel 2002 I would like to open particular workbook every time Excel starts, similar to how PERSONAL.XLS opens when I start Excel. As a test I saved a workbook in the same folder as the PERSONAL.XLS file, and sure enough it opened also with Excel. However, I would like this workbook, call it TestBook, to open up hidden like PERSONAL.XLS does, and I'd still like Excel to open a new workbook Book1.xls every time Excel starts. Is this possible? If so, how? Thanks! -gk- -- ================================================== ====================== "The creative act is not the province of remote oracles or rarefied geniuses but a transparent process that is open to everyone." -Greg Kot in Wilco Learning How To Die- |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Question about opening workbooks on Excel startup
This only works partially. When I open Excel it opens TextBook as hidden
but it does NOT open a new blank workbook, e.g. Book1.xls Any other suggestions? -gk- "Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote in message ... Open TestBook and hide it using Window | Hide. Be sure to save it when prompted. -- Vasant "38N90W" wrote in message ... Windows XP Pro Excel 2002 I would like to open particular workbook every time Excel starts, similar to how PERSONAL.XLS opens when I start Excel. As a test I saved a workbook in the same folder as the PERSONAL.XLS file, and sure enough it opened also with Excel. However, I would like this workbook, call it TestBook, to open up hidden like PERSONAL.XLS does, and I'd still like Excel to open a new workbook Book1.xls every time Excel starts. Is this possible? If so, how? Thanks! -gk- -- ================================================== ====================== "The creative act is not the province of remote oracles or rarefied geniuses but a transparent process that is open to everyone." -Greg Kot in Wilco Learning How To Die- |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Question about opening workbooks on Excel startup
I haven't tested this idea, but it sounds good.
In the Testbook, add a macro to "Thisworkbook" for the open event. (Can't remember the exact wording, something like Private Sub Open_Workbook or something--someone help here...) Anyway, the command "Workbooks.Add" will open a new workbook as you desire. Andy -----Original Message----- This only works partially. When I open Excel it opens TextBook as hidden but it does NOT open a new blank workbook, e.g. Book1.xls Any other suggestions? -gk- "Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote in message ... Open TestBook and hide it using Window | Hide. Be sure to save it when prompted. -- Vasant "38N90W" wrote in message ... Windows XP Pro Excel 2002 I would like to open particular workbook every time Excel starts, similar to how PERSONAL.XLS opens when I start Excel. As a test I saved a workbook in the same folder as the PERSONAL.XLS file, and sure enough it opened also with Excel. However, I would like this workbook, call it TestBook, to open up hidden like PERSONAL.XLS does, and I'd still like Excel to open a new workbook Book1.xls every time Excel starts. Is this possible? If so, how? Thanks! -gk- -- ================================================== ======== ============== "The creative act is not the province of remote oracles or rarefied geniuses but a transparent process that is open to everyone." -Greg Kot in Wilco Learning How To Die- . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Question about opening workbooks on Excel startup
I think I'd just put the equivalent code in the Auto_open procedure (in a
general module) of either personal.xls or testbook. sub auto_open() workbooks.add end sub (Andy was looking for Workbook_Open() under the ThisWorkbook module.) Andy wrote: I haven't tested this idea, but it sounds good. In the Testbook, add a macro to "Thisworkbook" for the open event. (Can't remember the exact wording, something like Private Sub Open_Workbook or something--someone help here...) Anyway, the command "Workbooks.Add" will open a new workbook as you desire. Andy -----Original Message----- This only works partially. When I open Excel it opens TextBook as hidden but it does NOT open a new blank workbook, e.g. Book1.xls Any other suggestions? -gk- "Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote in message ... Open TestBook and hide it using Window | Hide. Be sure to save it when prompted. -- Vasant "38N90W" wrote in message ... Windows XP Pro Excel 2002 I would like to open particular workbook every time Excel starts, similar to how PERSONAL.XLS opens when I start Excel. As a test I saved a workbook in the same folder as the PERSONAL.XLS file, and sure enough it opened also with Excel. However, I would like this workbook, call it TestBook, to open up hidden like PERSONAL.XLS does, and I'd still like Excel to open a new workbook Book1.xls every time Excel starts. Is this possible? If so, how? Thanks! -gk- -- ================================================== ======== ============== "The creative act is not the province of remote oracles or rarefied geniuses but a transparent process that is open to everyone." -Greg Kot in Wilco Learning How To Die- . -- Dave Peterson |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Question about opening workbooks on Excel startup
ps. I didn't test this either.
Andy wrote: I haven't tested this idea, but it sounds good. In the Testbook, add a macro to "Thisworkbook" for the open event. (Can't remember the exact wording, something like Private Sub Open_Workbook or something--someone help here...) Anyway, the command "Workbooks.Add" will open a new workbook as you desire. Andy -----Original Message----- This only works partially. When I open Excel it opens TextBook as hidden but it does NOT open a new blank workbook, e.g. Book1.xls Any other suggestions? -gk- "Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote in message ... Open TestBook and hide it using Window | Hide. Be sure to save it when prompted. -- Vasant "38N90W" wrote in message ... Windows XP Pro Excel 2002 I would like to open particular workbook every time Excel starts, similar to how PERSONAL.XLS opens when I start Excel. As a test I saved a workbook in the same folder as the PERSONAL.XLS file, and sure enough it opened also with Excel. However, I would like this workbook, call it TestBook, to open up hidden like PERSONAL.XLS does, and I'd still like Excel to open a new workbook Book1.xls every time Excel starts. Is this possible? If so, how? Thanks! -gk- -- ================================================== ======== ============== "The creative act is not the province of remote oracles or rarefied geniuses but a transparent process that is open to everyone." -Greg Kot in Wilco Learning How To Die- . -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
automatically opening an excel file on startup | Excel Discussion (Misc queries) | |||
opening workbooks on startup | Excel Discussion (Misc queries) | |||
Automatically opening several Excel Files at startup | Excel Discussion (Misc queries) | |||
Automatically opening several Excel Files at startup | Excel Discussion (Misc queries) | |||
To stop Excel from opening many workbooks at startup | Excel Discussion (Misc queries) |