Thread: How To Establish A Link Between Two Workbooks ?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default 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


Reply With QuoteReply With Quote