Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
xlBook.SaveAs (documentName) when file open by another process
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
xlBook.SaveAs (documentName) when file open by another process
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
xlBook.SaveAs (documentName) when file open by another process
Barry,
Remove the (..) from your statement. You are not using the return value (well there is not one as its a sub), so you do not they are not used NickHK wrote in message oups.com... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
XLBook.Save fails in Excel 2007 | Excel Programming | |||
How to get each spreadsheet to open in a seperate process? | Excel Discussion (Misc queries) | |||
Open Excel with a XML file and SaveAs XLS | Excel Programming | |||
Open a workbook as another Excel process | Excel Programming | |||
Open & process multiple worksheets then move them to different folder. | Excel Programming |