EXCEL-MACRO link between 2 documents
Closed
abcde
-
Jun 22, 2010 at 03:23 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jun 22, 2010 at 06:01 AM
venkat1926 Posts 1863 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.
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.
Related:
- EXCEL-MACRO link between 2 documents
- Tentacle locker 2 - Download - Adult games
- Feeding frenzy 2 download - Download - Arcade
- Fnia 2 - Download - Adult games
- My cute roommate 2 - Download - Adult games
- Resident evil 2 remake free download - Download - Horror
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Jun 22, 2010 at 06:01 AM
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
see this refernce
http://www.ozgrid.com/forum/showthread.php?t=42979