AfterRefresh

[JSoto]

Hello!

I looked around to see how to incorporate the query AutoRefresh event with no success. I'm just a beginner with VBA and I don't know how to use the code.

Here is the link that explains how to use the Query AfterRefresh event... http://support.microsoft.com/kb/213187

Here is my code:

Please Login or Register  to view this content.

As you can see, it's a simple code to open the workbook, refresh the linked query (from Access), save and close it.

Can you please help?

Thanks in advance!

[rgrant]

What exactly is happening, the code looks good...My guess is that the refresh did NOT complete before you did the save and close....

Not sure how to wait until done refreshing, but that may be something to look at...easy enough to test, just remove the save and close and see if it works....

[JSoto]

That's exactly what's happening. The link above (the one from microsoft support) explains a way around the problem but I don't know how to incorporate it to my code.

[rgrant]

ahh, I see. So what you probably should do is perform the save and close in an AfterRefresh Sub...see MS note below...

NOTE: To use the AfterRefresh event, in the above example, you can replace the macro name "qt_BeforeRefresh(Cancel As Boolean)" with "qt_AfterRefresh(ByVal Success As Boolean)." Also, change the message box text to an appropriate post data-refresh message.

[JSoto]

That is exactly the area that I need help with! Can someone help me? I will appreciate it!

[JSoto]

Guys,

Here is the solution to my problem in case you need it.

I finally figured it out!

This code goes on a Module:

Please Login or Register  to view this content.

This code goes on a Class Module:

Please Login or Register  to view this content.

Have fun!!