Right now for the saving I have it like this

Dim filename As String

filename = Range("A1")
ChDir "G:\Reports\First\"
ActiveWorkbook.SaveAs filename:= _
"G:\Reports\First\" & filename, FileFormat:= _
xlNormal, Password:="", WriteResPassword:="", ReadOnlyRecommended:=No
_
, CreateBackup:=False

If the file is already created and I choose not to overwrite, it
crashes.

I will try that code for the other part when I get back to work
tomorrow, thanks.

~J


--
nbaj2k
------------------------------------------------------------------------
nbaj2k's Profile: http://www.excelforum.com/member.php...o&userid=36480
View this thread: http://www.excelforum.com/showthread...hreadid=569162