Hi,

I wonder ais there any vba codes available to run the update link on
vlookup formula from a closed excel file as there are number of rows
using vlookup formula in 8 columns have to be manually updated the
links each time when there is a change of data in the source file

=VLOOKUP($A7,'C:\My Documents\P\ManagementAcct\Apr10\PAY\[KSW PL Co
compare1.Apr''10.xlsSheet(1)]P&L - COMPANY (compare 1)'!$A$3:$O
$60,2,FALSE)

Any help will be much appreciated and thanks in advance

Regards
Len