Resource / Time consuming macro
 

Hi.

I have a macro that because of its nature, takes over an
hour to complete - the code is fine, just processing lots
of data.

When I used to programme in Delphi, there was a method
called Application.ProcessMessages which allowed let the
CPU handle other tasks while churning away on the CPU
intensive code.

I was wondering if VBA has an equivalant? I can't seem to
find anything as currently I can't do anything else while
I run this macro.

Thanks for your help,
Bryan

Resource / Time consuming macro
 

Hi
AFAIK there's no such equivalent in VBA.

--
Regards
Frank Kabel
Frankfurt, Germany


Bryan wrote:
Hi.

I have a macro that because of its nature, takes over an
hour to complete - the code is fine, just processing lots
of data.

When I used to programme in Delphi, there was a method
called Application.ProcessMessages which allowed let the
CPU handle other tasks while churning away on the CPU
intensive code.

I was wondering if VBA has an equivalant? I can't seem to
find anything as currently I can't do anything else while
I run this macro.

Thanks for your help,
Bryan

Resource / Time consuming macro
 

Bryan,

See the 'DoEvents' function in VBE help for some thoughts on this.

HTH
Paul
------------------------------------------------------------------------

Hi.

I have a macro that because of its nature, takes over an
hour to complete - the code is fine, just processing lots
of data.

When I used to programme in Delphi, there was a method
called Application.ProcessMessages which allowed let the
CPU handle other tasks while churning away on the CPU
intensive code.

I was wondering if VBA has an equivalant? I can't seem to
find anything as currently I can't do anything else while
I run this macro.

Thanks for your help,
Bryan