Hello,

I'm trying to create a backup of the current active workbook using
SaveCopyAs, however, if the backup is currently opened (which is
conceivable in this case) a runtime error occurs (1004) stating that
it cannot access the file.

Is there a way to allow access to the opened backup file and update
it?

On a side-note, how can I check if the current workbook is the only
workbook opened?

(Excel 2002)

Any help would be apprecitated. Thanks.

Dan


---
Message posted from http://www.ExcelForum.com/