Created a Macro to copy from a closed or read only workbook

[Larry T.]

Hi Guys,

I created a macro to go to a sheet within a workbook and copy an area of information. My problem is: It works only if the file is NOT occupied. If someone is in the file I get a run error. Can someone assist in how to avoid and pull data if the workbook if open or closed?

Thanks a bunch

 

[vletm]

@Larry T.
Have You test link?
='[2ndBook.xlsx]Sheet1'!$A$1
All depends, how large range do You need...
=INDEX('[2ndBook.xlsx]Sheet1'!$A$1:$D$4;D1;D2)
Ideas ... Questions?

 

[Larry T.]

Thank you for the quick response. So, you are suggesting a more reliable process would be to INDEX instead of using a macro?

 

[vletm]

@Larry T.
I've used that 'INDEX' with a Macro.
loop set D1 & D2 -> read the answer
As I wrote, all depends HOW large range.

 

[Marc L]

Hi !

If the workbook is in shared mode, there are many restrictions
even within a VBA code …
​

 

[Larry T.]

Thank you guys for your input.

Regards,

Larry