SaveAs Macro - Specifiy Folder It Autoselects....

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top