mac7attack
Technical User
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
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