Question about wrappers for Office wizards OR about catching application level events.
Posted on 2014-10-02
I have a need to catch and act on the import of a table into an Access database. I'm sure there are dozens of better ways to do this than working inside of Access with VBA, but to save on typing all the details, suffice it to say I'm working within a legacy application and my users preference is to stick with what they know - Access.
I have searched the web with all my might and can't find the solution I would really like to implement.
One solution I thought of is wrap the import wizard in a VBA object so that I can provide some information to it as it is launched, and gather some information as it terminates. I can't find any example or documentation on how to do this.
The other option I thought of was to have an application level event that is triggered as a new file is imported to a local table. Again, I didn't find any good example or documentation on that.
The basic question is: are either of these possible? Or another way have any of you done anything similar where you could share how you solved the problem.
Any help or guidance is greatly appreciated.