I posted a question about this a while back (about a year ago). I never found the answer. I have gone back to tackle a problem I was having then.
I'm executing a macro that refreshes the data (Refresh Data Addon) I imported from an Access DB into Visio. How do I make the Refresh Data Summary window answer OK automatically after it completes? I already tried the Application.AlertResponse =IDOK, but the OK in the Summary window is not being detected by the AlertResponse.
I tried using a third party program which detects the window and closes it (Automatically Push My Buttons 2.1 from vsisoftware.com). When I tell this program to watch for the Refresh Data Summary window, it detects the window as #32770. I don't know what exactly I can do with that number in Visio, if anything at all.
I am using Visio 2003 Professional with SP1.
Thanks again!
Twixman23
I'm executing a macro that refreshes the data (Refresh Data Addon) I imported from an Access DB into Visio. How do I make the Refresh Data Summary window answer OK automatically after it completes? I already tried the Application.AlertResponse =IDOK, but the OK in the Summary window is not being detected by the AlertResponse.
I tried using a third party program which detects the window and closes it (Automatically Push My Buttons 2.1 from vsisoftware.com). When I tell this program to watch for the Refresh Data Summary window, it detects the window as #32770. I don't know what exactly I can do with that number in Visio, if anything at all.
I am using Visio 2003 Professional with SP1.
Thanks again!
Twixman23