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 |
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 |