Would anyone like to help me use the WorkbookBeforeClose event and SaveCopyAs method to save the active workbook under its current filename on a different drive?

Thanks