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

F

fahzia

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
 
P

Paul B

You can reference the other workbook in the formula, =[Book1.xls]Sheet1!$A$1
--
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
 
F

fahzia

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.


Paul said:
You can reference the other workbook in the formula, =[Book1.xls]Sheet1!$A$1
--
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")

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
Click to expand...
Click to expand...
 
Top