Pulling Specific Data from Excel

[DICKBUTTONS]

I have a database that needs to pull specific data from Excel.

Specifically, one specific Access field should go directly to a specific
cell in Excel and get that value.

I'm thinking that I use some kind of VBA code to open my
Excel file and assign the cell contents to a variable
which I then use in Access. I think I can find the cell
in Excel using a named range.

I need the exact code, though.

How do I do this?

[pbaldy]

As answered on one of the many sites you posted the question, the technique you're looking for is automation:

http://support.microsoft.com/kb/210288