Hyperlink and vlookup

 venkat1926 -

i have an file which i have to update every day using vlookup form other files each day have name with that day date eg (file1706) ... i have managed to creat an hyperlink to open it directly but need a code tht will open the update hyperlink n then take a vlookup ..with that day file name as i tried using macro ..that open the old file only

can anyone help me on this ....
thanks in advance .....

1 reply

You can do vlookup from a closesd workbook without opening that workbook There are many solutions if you google search ("vlookup excel from closed workbooks")

an eample
suppose referece data is in Book1.xls which is saved in folder "desktop"

the new file is book2

if you type this formla

=VLOOKUP(A3,'C:\Documents and Settings\Administrator\Desktop\[Book1.xls]Sheet1'!A1:B100,2,FALSE)

you will get an answer without opening the book1.cls . note single quote and exclamation mark.

easier way in book1.xls ;name the raference range for e.g "data

=VLOOKUP(A3,'C:\Documents and Settings\Administrator\Desktop\[Book1.xls]'!data,2,FALSE)