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
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
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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks