How to find the Excel application object that are defined in Access vba code

[chowmanhoi]

Hi all,

I am currently writing excel vba code on one of the worksheets page in vb editor...

The excel workbook is acted as a "shell" that will be used by an Access model which will fire off the Access vba code and automatically open the "shell" to feed in values from Access forms to the "shell". Therefore, in Access vba code, there is an excel application object being created...

Is there any vba statement that I can write on my code in excel workbook that it automatically tells me what excel application object the Access has created?

Any advice would help !!!

[mikerickson]

Perhaps

Please Login or Register  to view this content.