Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
At the end of a macro I have the following code:
strFileSvaeName = Application.GetSaveAsFilename("Test " & strMnth, _ fileFilter:="Microsoft Excel Workbook (*.xls), *.xls") If strFileSvaeName = "False" Then MsgBox "Action canceled." GoTo End_it End If ActiveWorkbook.SaveAs Filename:=strFileSvaeName, FileFormat _ :=xlNormal, Password:="", WriteResPassword:="", ReadOnlyRecommended:= _ False, CreateBackup:=False The WB that contains the macro also has a hyperlink in one of the cells. This cell is never referenced in the macro. However, when I run the macro, the default file save location is the hyperlink folder. I don't want that to be the default file save location. Have I explained this well enough for someone to tell me how to prevent it? -- Ken Hudson |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
SAVE and SAVE AS options disappeared from the drop down FILE menu | Excel Discussion (Misc queries) | |||
Excell2003 (SP-1) File > Save and File > Save As.. grayed out | Excel Discussion (Misc queries) | |||
Excel marcos firing on file save as but not file save | Excel Programming | |||
Save File to Another Directory, but not change Users File Save location | Excel Programming | |||
Save As - Multiple Sheets fails to save as text file | Excel Programming |