Run Script After Web Query Refreshes

[mac7attack]

Hello all,

I work at a Help Desk and we are trying to use Excel 2003 to monitor our Blackberry server.
This server using a table on a web page to display pending e-mails and such. I have set up a Web Query in an Excel spreadsheet that refreshes every 3 minutes. My question is it possible to run a VBA script directly after the Web Query is finished updating?
My thoughts on how to do this
- associate the script to the Web Query
- Use a VBA event such as Workbook_Open to run the script after the refresh is complete, something like Upon_refresh
- Use a timed VBA script to refresh and run the script.
but I could not figure out how to do any of the above.

Thanks for your help
Matt

 

[SkipVought]

Hi,

Check out

http://www.microsoft.com

for setting up a BeforeUpdate and AfterUpdate event in a Class module.

Skip,
[sub]
[red]Be Advised![/red] For those this winter, caught in Arctic-like calamity, be consoled...
Many are cold, but few are frozen![/sub]

 

[mac7attack]

I did some research within VBA help and found this code snippet.

Private Sub ConnectionApp_SheetPivotTableUpdate(ByVal shOne As Object, Target As PivotTable)

MsgBox "The SheetPivotTable connection has been updated."
End Sub

The question is does what "shOne" and "Target" are make a difference?

 

[SkipVought]

shOne is a worksheet object.
Target is a PivotTable object.

There will also be some code in a class module that defines and instantiates each of these objects.

look in

http://www.Microsoft.com

Skip,
[sub]
[red]Be Advised![/red] For those this winter, caught in Arctic-like calamity, be consoled...
Many are cold, but few are frozen![/sub]