Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
When I use the following code, the File/Save As Windows dialog box opens and
as long as a file name is supplied - the file saves properly. However, if you click Cancel and don't provide a file name - a false.xls file is created. Is there a way to avoid this? What I want is just for the save as function to cancel without a save. 'Prompts to save the TLR file with the appropriate name ChDir "U:\ACTUARIAL\Renewals" sFilename = Application.GetSaveAsFilename("", "excel files (*.xls),*.xls") ActiveWorkbook.SaveAs Filename:=sFilename |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
macro save a workbook whilst increasing file no | Excel Worksheet Functions | |||
Save as Msg box | Excel Discussion (Misc queries) | |||
Save as Msg box | Excel Discussion (Misc queries) | |||
cannot edit and save | Excel Discussion (Misc queries) | |||
Save & Save As features in file menu of Excel | Excel Discussion (Misc queries) |