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.

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.

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