Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
startup file
Hi:
I have a worksheet (form) that I would like to load at startup. I have moved a copy of the workbook to C:\Program Files\Microsoft Office\Office\XLStart and it loads as expected. But, if you change the form and use Save AS it loads the last form saved. Also if open filed is clicked before a file is saved the original default folder is displayed. My questions a What is the proper way to load a workbook as a startup? Also, force the new button to re-display that startup form if possible and the Save As workbooks sent to a default folder and the open button display the default folders saved files. I guess I would like it to work just as excel works now but uses my workbook as the startup and new workbook. Any help or direction will be greatly appreciated. TK |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
startup file
TK
If you save the workbook as a template in the XLStart directory and name it Book.xls, then it will be the default workbook when you start and when you create a new workbook from File - New. -- Dick Kusleika MVP - Excel www.dicks-clicks.com Post all replies to the newsgroup. "TK" wrote in message ... Hi: I have a worksheet (form) that I would like to load at startup. I have moved a copy of the workbook to C:\Program Files\Microsoft Office\Office\XLStart and it loads as expected. But, if you change the form and use Save AS it loads the last form saved. Also if open filed is clicked before a file is saved the original default folder is displayed. My questions a What is the proper way to load a workbook as a startup? Also, force the new button to re-display that startup form if possible and the Save As workbooks sent to a default folder and the open button display the default folders saved files. I guess I would like it to work just as excel works now but uses my workbook as the startup and new workbook. Any help or direction will be greatly appreciated. TK |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a settings startup file for Excel? | Setting up and Configuration of Excel | |||
File startup | Excel Discussion (Misc queries) | |||
Open a File on Startup | Excel Discussion (Misc queries) | |||
automatically opening an excel file on startup | Excel Discussion (Misc queries) | |||
open a file on startup | Setting up and Configuration of Excel |