How to refer to a a specific cell in Excel

[Eric]

Does anyone knows whether it is possible to refer
to a cell from a worksheet and store the value of
that cell in a variable using VBA? Is there an easy
way to accomplish that using Access VBA?

Many thanks.

 

[Douglas J. Steele]

What you want is referred to as "Automation". See, for example,
http://www.mvps.org/access/modules/mdl0006.htm at "The Access Web"

 

[Alex Dybenko]

Hi,
here a sample code:
http://support.microsoft.com/kb/141759/en-us

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com