Originally Posted by
:) Sixthsense :)
If possible try to use Indirect.Ext function of Morefunc Addin which you can get by doing a google search.
INDIRECT.EXT
Returns the value of a cell or range specified by its address (text string).
Unlike the INDIRECT built-in function, INDIRECT.EXT can also return the value of a cell whose workbook is closed.
SYNTAX :
=INDIRECT.EXT(Reference,Volatile,A1-Style)
Hi all!
Sorry for the delay to reply.
Sixthsense,
I appreciate your attention, but I wouldn't like to use the "INDERCT.EXT" and "Morefunc Addin", because I'll must install the addin on every PC to open the spreadsheet. The best solution that I've founded is the "Rylo" in this link > http://www.excelforum.com/excel-gene...nal-links.html, but I have to apply in my spreadsheet yet. I've attached it in this post as: "Example Measurements Workbook".
So... I had a little bit difficult to modify the VBA code cells range from "Rylo" Solution to my spreadsheet...
Could u or anybody handle me with this code?
The best way is use the path field as constant in all sheets... and when I need move the "Main Workbook", it will just change a single path file base (Main Secundary) to update all the woorkbook.
Below i've attached the zipped files and the code that I want to use.
Example Measurements Workbook by LeoAlves.zip
Dynamic Pathname for External Links Auto Updated by RYLO Macro.zip
Bookmarks