Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
This is the code I am using to save a report I am running.
fileSaveName = Application.GetSaveAsFilename (fileFilter:="Excel Files (*.xls), *.xls") If fileSaveName < False Then MsgBox "Save As " & fileSaveName End If ActiveWorkbook.Save ActiveWindow.Close How do I make it actually save the file as the name I specify in the Save box? It just saves it as Book 1,2, etc. Thanks in Advance, Donna Brooks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Please post this thread a correct full method, method about | New Users to Excel | |||
Please post this thread a complete correct method, method about te | New Users to Excel | |||
Help with getsaveasfilename | Excel Discussion (Misc queries) | |||
Another Method or 2? | Excel Discussion (Misc queries) | |||
GetSaveAsFilename not working in Excel 2003 | Excel Discussion (Misc queries) |