Running SQL Querry after every 10 minutes.

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
Harish said:
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.
Click to expand...

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

Mike
 
Mike Woodhouse said:
Take a look at Application.OnTime in VBA...

Mike
Click to expand...
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
 
Back
Top