macro's

[Dawn]

I am trying to write a macro prevent users from saving
files with the wrong file name and in the wrong location.

The File "Save As" screen will not allow me to reference a
cell for the file name. Is this even possible to do?

 

[Andy Brown]

"Dawn",

With full path & filename in A1
(C:\Documents and Settings\Andy\My Documents\Home.xls)

ActiveWorkbook.SaveAs Filename:= _
Range("A1"), FileFormat:=xlNormal _
, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _
CreateBackup:=False

worked for me. You could probably dump most of the arguments.

HTH,
Andy