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
Related:
- EXCEL-MACRO link between 2 documents
- Tentacle locker 2 - Download - Adult games
- Fnia 2 - Download - Adult games
- Euro truck simulator 2 download free full version pc - Download - Simulation
- Feeding frenzy 2 download - Download - Arcade
- 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