thomas.szwed
12-12-2007, 04:32 AM
I am looking to see if there is a way to run a marco/sub at a 11pm in the evening. I have created a new workbook with the following code.....what i want to do is for it to make a copy of anohter workbook - saving it in a pre determined folder. But i dont want any user interaction. Can the code do all of this itself?
Sub Backup()
Fname = NewStarterTracker.Name
Workbook("TestGood5").SaveCopyAs "\\ukyorw09\HR\IAC (file://\\ukyorw09\HR\IAC) New Starter Tracking\IAC\Application\Backup\ & Fname"
ActiveWorkbook.Save
ActiveWorkbook.Close
End Sub
I need to know how to nominate which workbook to backup. My current code Workbook(Itsname).SaveCopyAs doesnt work....do i need to put its path in somehow? Can ne1 help?
Sub Backup()
Fname = NewStarterTracker.Name
Workbook("TestGood5").SaveCopyAs "\\ukyorw09\HR\IAC (file://\\ukyorw09\HR\IAC) New Starter Tracking\IAC\Application\Backup\ & Fname"
ActiveWorkbook.Save
ActiveWorkbook.Close
End Sub
I need to know how to nominate which workbook to backup. My current code Workbook(Itsname).SaveCopyAs doesnt work....do i need to put its path in somehow? Can ne1 help?