Excel events implemented in Access

[Jess]

I have an access application which creates an excel sheet from scratch. How I
can implement excel events in access? For instance: How can I implement the
Worksheet_SelectionChange event in access? My guess is that this event cannot
be implemented in excel because the access generates my excel sheet from
scratch.

Any help is welcome

Thanks

 

[Banana]

I've not done it personally but I'm fairly sure you can do so, provided
you meet some prerequisites.

First, the code has to be in a class module. Can be a form as it's a
class or a standalone class module.

Second, you need a variable for the Excel objects (e.g. Application,
Workbook, Worksheet) with the keyword WithEvent declared.

Example:

Private WithEvents xlApp As Excel.Application

Thirdly, you need to declare a event handler for the variable. This can
be done by selecting xlApp from the left combobox on top of the code
windows, then choosing the desired event on right combobox.

I'm not sure if this can be done with late binding, though.

 

[David H]

What are you trying to do and what specific 'Events' are you referring to?

You can fully automate Excel from Access.