Hi Bob

From an external macro, something like

Sub test()
FileCopy "C:\temp\song.mp3", "D:\Anthems\song.mp3"
End Sub

from a macro within the file itself, something like

Sub test2()
ThisWorkbook.SaveCopyAs "D:\Anthems\" & ThisWorkbook.Name
End Sub

HTH. Best wishes Harald

"Robert Gillard" skrev i melding
k...
I need to automate the copy of a workbook.? I have an Excel
spreadsheet located at C:\Reports\Test.xls, I need to copy it to
D:\BackUpReports\

What is the best way to do this.

With thanks

Bob