$$Excel-Macros$$ Excel 2010 VBA Priority

2012-10-26 Thread Paul Schreiner
I have macros that run for several minutes (usually updating an Oracle database) I update the StatusBar to indicate progress, like: if (nRec mod 1000 = 0) then Application.Statusbar = "Processing " & nRec & " of " & nRecordCount I've noticed that after a few cpu cycles, Excel goes into "Backg

RE: $$Excel-Macros$$ Excel 2010 VBA Priority

2012-10-26 Thread Asa Rossoff
Excel process to Above Normal or High. Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Paul Schreiner Sent: Friday, October 26, 2012 5:22 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Excel 2010 VBA Priority I have macros

Re: $$Excel-Macros$$ Excel 2010 VBA Priority

2012-10-30 Thread Paul Schreiner
ff To: excel-macros@googlegroups.com Sent: Fri, October 26, 2012 3:09:02 PM Subject: RE: $$Excel-Macros$$ Excel 2010 VBA Priority Hi Paul, I don't know the answer to your whole question, but using DoEvents periodically should ensure you can interrupt the macro, that screen painting c