| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SaveAs - - provide option to Save As .xlsm or .xls
I have the following snippet of code
filesavename = Application.GetSaveAsFilename( _ InitialFileName:=SuggestedName & ".xls", _ FileFilter:="Excel Files (*.xls), *.xls") How would I need to change this supply a suggestedname for either XLS or XLSM files. When I use this, it's only .XLS I think what I'm wanting is a File Filter that includes xls and xlsm. Can this be done? If so, I guess I need to change the initial file name somehow. Suggestions? Thanks, Barb Reinhardt |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Provide option to specify level of difficulty of the Question | Excel Discussion (Misc queries) | |||
| Can't save xlsm as web page | Excel Discussion (Misc queries) | |||
| Can't save a .xlsm as a web page | Excel Discussion (Misc queries) | |||
| SaveAs XLSM question | Excel Programming | |||
| SaveAs works on one PC, not another. "Save" not really an option. What to do? | Excel Programming | |||
Threaded Mode
