open another workbook
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 |
open another workbook
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 |
open another workbook
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 |
All times are GMT +1. The time now is 10:07 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com