Excel-Import Data

[gabbie]

I am importing data by means of a msquery. The data is gathered from Microsoft SQL express 2005 database. I want to set up each worksheet to refresh automatically at time intervals and to only allow a restricted amount of data to transfer into the worksheet.

How do I approach this?

[Don]

*moved to the programming forum

Hi and welcome!

All you need to do is to use the macro inserted below and input the name of your macro. This will run the desired macro every so many minutes after the first time it is run.

Code: Select all

Sub ReRunMacro()
   
    Call test
   
    Application.OnTime Now + TimeValue("00:02:00"), "ReRunMacro"
   
End Sub

Replace "test" with the name of your macro. Change the 2 after "TimeValue" to however many minutes you want to have between running the macro.

As far as restricting the data taken in by the query, just deal with that in the macro that this macro will call.

hth!