how to access a cell value in a different workbook. HELP!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

fahzia@gmail.com - 18 Oct 2006 21:04 GMT

here is how my function looks like. Also i am using this in formula
like =check("A1")

function check(cell)
{
if cell>50
get the new valuue from a differnt workbook
}

can someone PLZ tell me how will i get the value from a different
workbook. I have to use this value in my function, can this be done in
a macro. I can open the second workbook if need be . please help

Reply to this Message

Paul B - 18 Oct 2006 21:23 GMT

You can reference the other workbook in the formula, =[Book1.xls]Sheet1!$A$1

Signature

Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

> here is how my function looks like. Also i am using this in formula
> like =check("A1")
[quoted text clipped - 8 lines]
> workbook. I have to use this value in my function, can this be done in
> a macro. I can open the second workbook if need be . please help

Reply to this Message

fahzia@gmail.com - 18 Oct 2006 21:32 GMT

is there anyway i can use it in my function rather than directly
putting in a formula bar. Its because the value to get is dynamically
fetched and my function is already taking care of other conidtions.

> You can reference the other workbook in the formula, =[Book1.xls]Sheet1!$A$1
> --
[quoted text clipped - 16 lines]
> > workbook. I have to use this value in my function, can this be done in
> > a macro. I can open the second workbook if need be . please help

Reply to this Message