Retrieving Data From an Open Access Session (Excel 2003) 1

[stephenj789]

I have both Excel and Access open (both 2003). Access has a form open. I would like an Excel macro to use values that are in the Access form. How could I go about doing that?

 

[PHV]

A starting point:
Dim acApp As Object
Set acApp = GetObject(, "Access.Application")
MsgBox acApp.Forms("name of form").Controls("name of control").Value

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[stephenj789]

I was able to get it to work. Thanks again PHV!