Menu

xlBook.SaveAs (documentName) when file open by another process

Search this Thread

Prev

Previous Post

Next Post

Next

#2

Report Post

Posted to microsoft.public.excel.programming

[email protected] bg_ie@yahoo.com is offline

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 Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
XLBook.Save fails in Excel 2007	D.P. Roberts	Excel Programming	1	November 27th 06 07:38 PM
How to get each spreadsheet to open in a seperate process?	Horrgakx	Excel Discussion (Misc queries)	3	November 21st 06 02:57 PM
Open Excel with a XML file and SaveAs XLS	Li Pang	Excel Programming	0	July 3rd 06 10:17 PM
Open a workbook as another Excel process	Stephen Bullen[_4_]	Excel Programming	0	December 22nd 04 09:27 AM
Open & process multiple worksheets then move them to different folder.	Prasad Vanka	Excel Programming	1	May 18th 04 03:26 PM

All times are GMT +1. The time now is 10:21 PM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement