Hi
I have a macro that I need to save to the network drive (R). The only
problem is that the macro below when U run it save the files to the documents
folder. I have no ideas why this is happening. If anyone has any ideas as to
why this is happening I would be VERY grateful for the help.


Sub Saveas()
'
' Saveas Macro
' Macro recorded 10/11/2007 by
'

'
ChDir "R:\Production Reports\Production Summary Report\Daily Production
Summary Copies"
ActiveWorkbook.Saveas Filename:= _
"Production Summary Report" & Format(Date, "mm-dd-yy") & ".xls", _
FileFormat:=xlNormal, Password:="", WriteResPassword:="", _
ReadOnlyRecommended:=False, CreateBackup:=False
End Sub