PDA

View Full Version : Solved: Trigger code from SQL Query refresh



peacenik
05-09-2006, 08:18 PM
I have some code that I would like to run immediately after each time I refresh my ODBC query in a spreadsheet. Can someone please tell me what event I can use to trigger my code.

lenze
05-10-2006, 08:11 AM
Untested, but I believe a query refresh will trigger a Worksheet_Change event, so you could us that to fire your query.

lenze

peacenik
05-10-2006, 05:43 PM
Thanks. That did the trick perfectly.

geekgirlau
05-10-2006, 07:48 PM
Peacenik, don't forget to mark this thread as "Solved" using the Thread Tools at the top of the screen.