Auto update...

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
 
K

KJTFS

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
 
F

Fu Manchu

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
 
Top