Hi Dave

Try the following?

Sub SaveCopy()
ChDir "C:\Documents and Settings\{Enter new Directory name here}"
ActiveWorkbook.SaveAs Filename:= _
"C:\Documents and Settings\{Enter new directory and file name here},
FileFormat:=xlNormal, Password:="", WriteResPassword:="", _
ReadOnlyRecommended:=False, CreateBackup:=False
End Sub

This is the result of running Macro Record, but you can adapt it to suit
your needs.

--
ve_2nd_at. Randburg, Gauteng, South Africa


"Dave" wrote:

Is there a way to use a macro in a workbook to move a file from one folder to
another folder by copying it? I tried to record a macro to do it but nothing
shows up in the VB editor.

Thanks
Dave