Macro Problem with calls

Hello,

I have problem in which I would like to keep a worksheet
open all of the time and have a macro check what is in the
sheet every few minutes. Is there some kind of call
function to have excel execute the macro every few minutes
infinitely? Any suggestions would be greatly appreciated.

Thanks, SP

You can probably do it with vba and the timer control.

Kim

"Sandip Patel" <spatel@bpwllc.com> wrote in message
news:0c3201c347c9$ce770110$a501280a@phx.gbl...
> Hello,
>
> I have problem in which I would like to keep a worksheet
> open all of the time and have a macro check what is in the
> sheet every few minutes. Is there some kind of call
> function to have excel execute the macro every few minutes
> infinitely? Any suggestions would be greatly appreciated.
>
> Thanks, SP

Take a look at Chip Pearson's notes:

http://www.cpearson.com/excel/ontime.htm

Sandip Patel wrote:
>
> Hello,
>
> I have problem in which I would like to keep a worksheet
> open all of the time and have a macro check what is in the
> sheet every few minutes. Is there some kind of call
> function to have excel execute the macro every few minutes
> infinitely? Any suggestions would be greatly appreciated.
>
> Thanks, SP

--

Dave Peterson
ec35720@msn.com