How To Establish A Link Between Two Workbooks ?
 

I need to put in a cell a formula that refer to another workbook... how can I
do that?

--
Message posted via http://www.officekb.com

How To Establish A Link Between Two Workbooks ?
 

Try something like

='H:\[book2.xls]Sheet1'!A1

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"MarcL via OfficeKB.com" <u19204@uwe wrote in message
news:5d35c5d411c31@uwe...
I need to put in a cell a formula that refer to another
workbook... how can I
do that?

--
Message posted via http://www.officekb.com

How To Establish A Link Between Two Workbooks ?
 

activecell.formula = "='C:\My Folder\[My Book.xls]Sheet1'!A1"

--
Regards,
Tom Ogilvy


"MarcL via OfficeKB.com" <u19204@uwe wrote in message
news:5d35c5d411c31@uwe...
I need to put in a cell a formula that refer to another workbook... how
can I
do that?

--
Message posted via http://www.officekb.com