Hi folks,
Does the SaveCopyAs command in a macro HAVE TO create a temporary file
?
I feel like it is just slowing down the already lengthy process of
saving and copying my file twice. First is just saves itself and then
it copies it to a backup drive. The latter of the two operations
seems to take a long time on this 3500k file.


This is the current macro:

Sub Backup()
Fname = ActiveWorkbook.Name
ActiveWorkbook.Save
ActiveWorkbook.SaveCopyAs "J:\Trading\" & Fname
End Sub