Excel Automation - How to handle excel events from Access
Posted on 2004-04-10
I have an Access 2002 application that has a form with an embedded Excel OLE object. Using a button, i allow the user to open the embedded excel app, and thus let the user interact with the Excel file. Now, I would like to be able to detect which cell(s) the user has selected whenever they choose a different range of cells. I realize that a WorkSheet object has a "SelectionChanged" event that fires when the user chooses a different cell, however, I want to be able to do this from the Access parent app. I figure, the best way to do this would be to:
1) Handle the "SelectionChanged" event from the Access parent application that is hosting the embedded OLE Excel file
2) Be able to RETURN to the Access application the new range of cells that have been selected
Any help would be appreciated.