Auto update...

  • Thread starter Thread starter Fu Manchu
  • Start date Start date
F

Fu Manchu

Hi

I'm looking for a script that auto updates from another excel-shee
(called "sheet one"). please help me...

I'm looking for a script that auto updates every 5 minutes - not once
but every 5 minuts. I'm new at VBA and are reading several book abou
VBA.

Kindly
Fu Manch
 
You will want to use the
Application.OnTime Now + TimeValue("00:05:00"), "Proc_Name"

then have the sub or routine named Proc_Name do whatever updating you
want done.

Then at the end of the Proc_Name macro put the same ontime event so it
will recursively call itself.

Keith
www.kjtfs.com
 
Now someone may think that i'm an idiot at VBA

But could someone please show me the hole skript. The Sub rutine?!?

Yes, i know... I'm a totally beginner at VBA, but are struggeling t
learn.

Kindly
Fu Manch
 
Back
Top