How to refresh a web query every x mn?

  • Thread starter Thread starter Pat
  • Start date Start date
P

Pat

Hi everyone,
I'm running a web query from an Excel 97 file, the data on the web site
change about every 10 mn.I'd like to use a macro to refresh my query
every 10 mn or so as well.I've got all I need in my VBA code except for
this aspect.
So my question is either :How to refresh a web query every x mn? or
How to run a macro every x minutes ?
I'd appreciate any help you could give me.
Thanx.
 
Many Thanks,
I'll try that next week.
Altough I've hoped that there would be a simpler way built-in, sthg
like "repeat sub() every 10 mn", but that would too simple I guess -:)
 
Back
Top