Ok I get the conditional now but I’m still having problems with the
backup thing. I see all the examples are backing up the active
workbook. This is not the case with my situation. The file I need to
back up is located he
C:\Documents and Settings\Dan Sharron\Mrs\Admin\Execution\Mrs 2005
Data-Ver1 1.xls
I would like to just make a copy of this file and call it:
C:\Documents and Settings\Dan Sharron\Mrs\Admin\Execution\Mrs 2005
Data-Ver1 1 Backup.xls


--
sungen99
------------------------------------------------------------------------
sungen99's Profile: http://www.excelforum.com/member.php...fo&userid=9144
View this thread: http://www.excelforum.com/showthread...hreadid=475370