if you have this for an open workbook
=VLOOKUP(A5,[yourworkbook.xls]yourworksheet!$A$5:$C$10,2,0)
when you close, excel will automatically change to
=VLOOKUP(A5,'C:\yourfolder\yourworkbook.xls]yourworksheet'!$A$5:$C$10,2,0)
Notice the addition of the path and the ' and the precise location.
--
Don Guillett
SalesAid Software
"choice" wrote in message
...
i have workbook register.xls that looks up values from data.xls
so i need a startup macro that opens data.xls before register.xls
thanks in advance