EXCEL-MACRO link between 2 documents

Closed
abcde - Jun 22, 2010 at 03:23 AM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jun 22, 2010 at 06:01 AM
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

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Jun 22, 2010 at 06:01 AM
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
0