I have some VBA code which does a special paste and sort which I want to do every time I refresh a certain query. I am having little luck working through the example on the VBA help menu about how to use the Query Table events. From the description I could not tell where to put the code, and where to plug in my own subroutine into the example. Here is what I tried.
I created a Class Module and called it ClsModQT. Then tried to "connect the declared object in the class module to the object. Following the example, here is what I put into that module:
(Then my own subroutine)
Nothing happens at all. This subroutine works fine when I run it myself.
What am I doing wrong?