Perpetual Macro in Excel

[zsfhaergta]

Hi,

I'd like to have a macro perform real-time operations to an excel file while it is open. It would be similar to a forever loop running on a separate thread. It would perform operations upon data updates or at certain times. Is something like this possible?

Thanks,
Allen

 

[SkipVought]

Hi,

What have you tried? Noticed you posted in the VB forum originally.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[zsfhaergta]

Ya, I read into Application.OnTime and that worked well for what I wanted.

Thanks

 

[SkipVought]

Nice to know that your question has been resolved.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]