Thread: xlBook.SaveAs (documentName) when file open by another process
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] bg_ie@yahoo.com is offline
external usenet poster
  
Posts: 21
Default xlBook.SaveAs (documentName) when file open by another process

skrev:

When I attempt to use the line -
xlBook.SaveAs (documentName)
to save an excek document I have created (or edited), I get an error
when this document is open by another process. I'm creating this excel
doc within visio and the problem will occur if the client already has
this file open with excel. How might I handle this situation?

Thanks for your help,

Barry.

Here what I'm doing now.

On Error Resume Next
xlBook.SaveAs (documentName)
On Error GoTo 0

Does it seems ok?

Reply With QuoteReply With Quote