Hi,

ActiveWorkbook.Save
ActiveWorkbook.SaveAs Filename:= _
"N:\2009 Uploads\GLL\GLL 2009 TB.xls", FileFormat:=xlExcel8,
Password:="", WriteResPassword:="", ReadOnlyRecommended:=False _
, CreateBackup:=False

Change the directory and name to fit your needs just need to change this
N:\2009 Uploads\GLL\GLL 2009 TB.xls

if this helps please click yes, thanks

"RMires" wrote:

I've created a button to save a file with a name created from a cell, but I
need to be able to save it to a particular location which is other than the
default location.