Greetings,

I have a spreadsheet containing a macro that fills in cells with data
fetched from an SQL database via ODBC.

How do I get the data to refresh automatically if the source SQL data
changes? For example:

Someone opens the sheet, the macro fires, and the sheet is filled with data.
Then, someone else adds data to the source SQL table, and... I'd like the
sheet to update automatically. I guess this would involve a sort of
persistent ODBC connection, but I have no idea how to go about this.

Thanks for any suggestions!

-John



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.537 / Virus Database: 332 - Release Date: 11/6/2003