Grab Cell Data from open Excel Document

[sgfromny]

I'd like to have some code that can see an existing and open excel document, go to pre-named cells and retrieve the data to then be put into an access table.

I want to do this from Access.. I know how to send the data to the tables. I just need to know how to get access to see the open excel sheet.

Help appreciated!

 

[Remou]

You should be able to use the FindWindow API

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

and SetActiveWindow

 

[PHV]

Have a look at the GetObject function:
Set myXL = GetObject(, "Excel.Application")
MsgBox myXL.Range("pre-named").Value

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886