SaveAs Macro - Specifiy Folder It Autoselects....

[Z Nicodemous]

Hi There,

I am using a Macro to throw up a "Save As" Prompt when someone creates a new
spreadsheet.

I would like to know if its possible to make it so that when the "SaveAs"
prompt it thrown up, it automatically is in thefolder "w:/PCD Service
Desk/Jobs/"

Here is the code for the save as macro im using:

'Retrieve file name to use for Save
fileSaveName = Application.GetSaveAsFilename( _
fileFilter:="Excel Files (*.xls), *.xls")

'If user specified file name, perform Save and display msgbox
If fileSaveName <> False Then
ActiveWorkbook.SaveAs Filename:=fileSaveName, FileFormat:=xlNormal

MsgBox "Save as " & fileSaveName
End If


This isnt something i made myself, i found the code for it on the internet
that someone was kind enough to share.

I hope someone can help

Regards
Zach Nicodemous

 

[Steve Schapel]

Zach,

The focus of this newsgroup is macros in Access, the database tool,
which are quite different from macros in Excel. You will probably get
better help in an Excel newsgroup.