G
Guest
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=MTUSER;"
.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
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=MTUSER;"
.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