Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Run Macro on External Data Refresh

I want to run a macro after Excel automatically updates a
query from the internet.

I am using Excel 2003. The query is a refreshable web
query that is set to automatically update every minute,
without the user hitting the refresh button. The
workbook has 20 web queries in 20 different sheets, and a
master sheet that collects and summaries the data on the
20 sheets.

I would like for the macro to run after all 20 have been
updated. The refresh occurs automatically in the
background every minute, and the macro does not initiate
another refresh.

I want the software to work without the user constantly
hitting refresh.

Thanks, John Witte

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Refresh table with external data? David K. Links and Linking in Excel 0 November 5th 09 08:57 PM
External data refresh Texas Tonie[_2_] Excel Discussion (Misc queries) 1 April 17th 07 11:02 AM
external data automatic refresh through macro/query Texas Tonie[_2_] Excel Discussion (Misc queries) 0 April 12th 07 07:52 PM
external data refresh shoreguy Excel Discussion (Misc queries) 0 March 7th 06 06:30 PM
Run Macro on External Data Refresh John Witte Excel Programming 3 December 3rd 03 01:42 PM


All times are GMT +1. The time now is 03:14 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"