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

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

is there a way around that. because i have the workbooks on 3 different
computers that lookup info from data.xls which is shared.
could i do a find replace when register.xls opens to replace c:\etc with
[data.xls]inventory!

"Don Guillett" wrote:

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