Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Importing a collection of WB's where one or more WB's is alreadyopened by a 3rd party
My copying all Sheets2 only, values only, from all workbooks from From
Folder A to new workbooks in Folder B, is tested and works fine. Now, I want to introduce in my test where one or more workbooks, unknown to me, are already opened by a third party. At some point the execution stops to prompt me that a workbook is already open and whether I want to reopen it or not. The question is : Can this interruption be ignored by code ?, considering that I do not want to re-open the workbook if it is already open. If the code is not a mile long, can you help me, or point me in the right direction ? Thank you, J.P. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unique value party | Excel Discussion (Misc queries) | |||
Third-Party Add-in, Names | Excel Programming | |||
Referencing another WB's cells, but not formulas/values. | Excel Worksheet Functions | |||
3rd party add ins for XL 07 | Excel Discussion (Misc queries) | |||
Copy-Paste between sheets in dif WB's | Excel Programming |