Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting "save as" and "save"
"I have an access application which generates an excel sheet; excel is
launched from access. I would like to implement the following behavior. Whenever my user clicks €śsave€ť or €śsave as€ť excel should filled out the "file name" field with a given name I will choose €“excel uses book1 as default and I do not wish this. Additionally the €śsave as€ť combo box should be set to macro-enabled workbook. How can I accomplish this? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting "save as" and "save"
Check out the Excel.Application.GetSaveAsFileName Method.
http://msdn.microsoft.com/en-us/libr...ffice.11).aspx --JP On Oct 1, 1:27*pm, Jess wrote: "I have an access application which generates an excel sheet; excel is launched from access. I would like to implement the following behavior. Whenever my user clicks “save” or “save as” excel should filled out the "file name" field with a given name I will choose –excel uses book1 as default and I do not wish this. Additionally the “save as” combo box should be set to macro-enabled workbook. How can I accomplish this? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selecting "Save As" adds "Copy of" to file name- MS Excel 2007 | Excel Discussion (Misc queries) | |||
"CELL("FILENAME") NOT UPDATE AFTER "SAVE AS" ACTION | Excel Discussion (Misc queries) | |||
ie Command to Wait for "File Download" and "Save As" windows | Excel Programming | |||
"Save" and "Save As" options greyed out - "Save as Webpage" option | Excel Discussion (Misc queries) | |||
"Subscript out of range" error for: Workbooks("Test1.xls").Save | Excel Programming |