Automatic screen refresh during import

[Donald Van den Driessche]

Hello

I'm looking for a way to supress the flickering of the MSP during import
from VB.
Because when it's a large project, the flickering is quit heavy.

I already tried something with oApp.ScreenUpdating = False, but that didn't
work.

Can anyone help me?

Thx
Donald

 

[Rod Gill]

Yeah, that Excel method isn't supported. I find the easiest way is to make
sure you use a Project variable to point to the current project then open
and always have active a blank project. I also use the Name for task 1 as a
status message for progress. Once the macro has finished, close and don't
save the blank project. Because of the blank project there are no screen
updates and progress is much faster.