Hi,

If anyone can help me on below, it will be a great help for me.

I have an excel file with 2 VBA module:
Module1: Essbase declaration
Module2: Macro to prepare excel report including essbase retrieve.

When I run Module2 macro in excel it works absolutely fine.

Now, I want to do it with access as below:

I have prepared a form, created an option button. I want the Module2 macro to be run as soon as I click on that option button.

Is this possible. Please let me know.

Many Thanks in advance.....