EXCEL-MACRO link between 2 documents

Closed
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Hello,
I am working on a table(in document A) which needs to be referred to another document(document B, not sheet 2 of document A). I used macro to link the data and it works perfectly well when both documents are opened. However, once I closed document B, the data on the table cannot be shown with a message " subscript out of range".
What can I do to avoid this so that I only have the open the main sheet as to get all my data on the table?
Thanks.


1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
It is theoretically possible to refer to a cell in closed workbook in a macro in open workbookby using a function.I heard it has limitations. so what you ahve to do is throught he macro open the closeds workbook and close it by the same macro when the work is over. why souch tortuous procedure . why not keep both workbooks open


see this refernce

http://www.ozgrid.com/forum/showthread.php?t=42979