Hi All

I have one SQL Querry which I run in background using following code in VBA
macro.

With Selection.QueryTable
.Connection = "ODBC;DSN=MTRAC;UID=mtuser;PWD=mtuser;SERVER=MTUSE R;"
.Refresh BackgroundQuery:=False
End With

This works fine when I run the VBA macro. But I want to run this query in
every 10 minutes for continuous monitoring of the data. I have one standalone
PC for this application where this excel workbook is open all the time. I
know I can use windows scheduler to open this workbook and run the query when
workbook opens. But I am just wondering if there is any other way to do this.

Your help would be greatly appreciated.

Kind Regards
Harish