Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
From the VBE help
--------------------------- GetSaveAsFilename Method : Displays the standard Save As dialog box and gets a file name from the user without actually saving any files. SaveAs Method : Saves changes to the sheet (Syntax 1) or workbook (Syntax 2) in a different file. ActiveWorkBook.SaveAs Filename:=fileSaveName ---------------------------------------------------------------------------- I'm assuming that you want to save the ActiveWorkBook with a new file name. HTH Paul -------------------------------------------------------------------------------------------------------------- Be advised to back up your WorkBook before attempting to make changes. -------------------------------------------------------------------------------------------------------------- |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help with getsaveasfilename | Excel Discussion (Misc queries) | |||
GetSaveAsFilename not working in Excel 2003 | Excel Discussion (Misc queries) | |||
GetSaveAsFilename method | Excel Programming | |||
Excel 2002 GetSaveAsFileName | Excel Programming | |||
File save location with Application.GetSaveAsFilename | Excel Programming |