Retrieving Values from another Excel Workbook Using Text References

[Elmer Valdez]

how can I store excel cell value to access database and
how can I retrieve cell value from database to my excel workbook?

thank you

[email protected]

[Alvin Linardi]

Can you give a example in excel worksheet for this tip.
Retrieving Values from another Excel Workbook Using Text References
http://www.exceltip.com/st/Retrieving_Values_from_another_Excel_Workbook_Using_Text_References/981.html

Thanks,Alvin
[email protected]

[ExcelTip]

Problem:

Listed in column A are the path, file name, sheet name, and cell reference for a range containing pairs of numbers and letters.
We want to lookup each of the numbers in column C in the range specified in column A and retrieve the matching letters.

Solution:

To retrieve the values listed in column C in the range specified in column A, use the VLOOKUP and INDIRECT function as shown in the following formula:
=VLOOKUP(C2,INDIRECT(\"\'\"&$A$2&\"\\[\"&$A$5&\".xls]\"&$A$8&\"\'!\"&$A$11),2,FALSE)

[vkohli]

how can I do the above when the other workbook to which I am referencing is closed. In this case, the indirect function will throw up an error. I am simply trying to link a cell in a wkbook with another.

Am using this formula,

A1=INDIRECT("'[FirstName "&RIGHT(myname(),10)&"]"&"Master"&"'!"&"A1")

myname is a function that I have defined which throws up the value of the workbook in which you are working.

It gives FirstName Apr 07.xls

right(myname(),10) then can be used to refer to different months depending on the wkbook.

Please help.

[tmarzean]

I need to change a a Week number to a date.

1 will equal 1/06/07
2 will equal 1/13/07
3 will equal 1/20/07