| 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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Importing a collection of WB's where one or more WB's is already o
You can open the file read only. Dong this you will be reading the values as
they were the last time the file was saved... -- HTH... Jim Thomlinson "u473" wrote: 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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Importing a collection of WB's where one or more WB's is alreadyopened by a 3rd party
On Dec 2, 9:04*am, u473 wrote:
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. You could open the file in readonly mode ie. Application.Workbooks.Open Filename:="C:\MyFile.xls", ReadOnly:=True |
| Reply |
| 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 | |||
Linear Mode
