Referencing names from one excel file into another
Posted by Carl Wells on August 06, 2001 8:08 AM
still grapelling with excel's address/name handling, mainly because I'm still a bit of a newbie :(.
Anyway, I am currently using the command
'G:\Carl\ArbitrageTemplates\[Carl MW template 1.xls]NAV calculations'!NAV
in order to read the value of the name NAV in sheet NAV calculations in workbook Carl MW template 1.xls into the current cell.
This is nasty for 2 reasons :
(i) I need to know what sheet the name is located in (this is really bad ... previously I was using
which worked pretty well, but I can't get this to work across files ...
(ii) I then need to be able to specify which column of the name I want to get the value from