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

Harish wrote:
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.

Take a look at Application.OnTime in VBA...

Mike

"Mike Woodhouse" wrote:


Harish wrote:
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.

Take a look at Application.OnTime in VBA...

Mike


Thanks for your reply.I have used this function but it is quite lenghty
code.As for I have to refresh in every 10 minutes.So for 24 hours I need to
write 144 lines of code.
Is there any other way to do this?

Kind Regards
Harish