Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel template and default save name
I'm using excel 2003.
When I open my template (xlt) file via double clicking and then exit excel, the saveas dialog is displayed using the template file name with an xls extension as the default name. Is there a way I can set the default name to be the content of one of the cells in the template? I want to force the default name of the file. This needs to work with the save, saveas and exit function. Thanks, - Pat |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel template and default save name
Select Case file_reference
Case xls file_type = "xlNormal" .. .. .. End Select ActiveWorkbook.SaveAs Filename:= _ Cell_Reference, FileFormat:=file_type, _ Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _ CreateBackup:=False Where Cell_Reference is the cell that has the file name and file_reference is the cell holding the file type you desire. file_type is your variable to hold the excel back-end name for your file type. "Dreiding" wrote: I'm using excel 2003. When I open my template (xlt) file via double clicking and then exit excel, the saveas dialog is displayed using the template file name with an xls extension as the default name. Is there a way I can set the default name to be the content of one of the cells in the template? I want to force the default name of the file. This needs to work with the save, saveas and exit function. Thanks, - Pat |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to make a .XLTM template file default to save as .XLSM type? | Excel Discussion (Misc queries) | |||
Need Help with Default Template in Excel | Excel Discussion (Misc queries) | |||
Setting a default save folder for a template | Excel Discussion (Misc queries) | |||
Excel template to load automatically as the default template? | Excel Discussion (Misc queries) | |||
Default excel Template | Excel Programming |