Use RunCommand to close AdvFilter window?

P

Paul Johnson

I have placed the following lines in a sub to give users direct access to
the Advanced Filter/Sort||Load from Query window:

RunCommand acCmdAdvancedFilterSort
RunCommand acCmdLoadFromQuery
RunCommand acCmdApplyFilterSort

Everything works as expected, but I would like the sub to clean up after
itself after the Filter is applied, by closing the Filter/Sort window, now
open behind the active window. I tried looking at the Screen and
Application objects, but I haven't found a way to access the open window.
Any ideas?

TIA

Paul Johnson
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Load from Query via VBA 2
Creating button to prompt custom filter window 3
ADVANCE FILTER SORT WINDOW 1
Load From Query via VBA 0
RunCommand acCmdFind causes "Error 2046: ... Find isn't available now" 11
problem with RunCommand accmdWindowClose work 1
Creating button on form to prompt custom filter window 0
Open to Blank Form 5

Top