open another workbook

[Guest]

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

 

[Don Guillett]

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.

 

[Guest]

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!

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
(e-mail address removed)

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