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

--
Message posted from http://www.ExcelForum.com

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


---
Message posted from http://www.ExcelForum.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

--
Message posted from http://www.ExcelForum.com