View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
dule[_4_] dule[_4_] is offline
external usenet poster
 
Posts: 1
Default SaveCopyAs cannot access opened file?

Thank you for the replies.

Kelston, I tried your method, but if the file is opened, it tells m
that it cannot save to the same name as an opened workbook.

I ended up closing the workbook before trying to backup. Thanks Jake

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