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.