Suppress popup message for password

[diakonos1984]

I have an Excel VBA macro that takes a long time to run, as it has to perform cut-and-paste operations on 65,000 rows of data, two rows at a time. I'm working on some speed optimization techniques, but that's another story.

In the meantime, I just let the macro run overnight!

However, I've noticed when I get up in the morning, that the macro has paused, apparently because I have a pop-up window from Microsoft Outlook asking for my password to my Exchange server! I close the pop-up window, and the macro resumes execution.

Outlook isn't open, (in fact no programs are open but Excel), yet it has processes that insist on performing this check. I don't really want to turn the processes permanently off, but it would be nice if I could suppress them so that it didn't hang my macro halfway through.

Anybody else seen this?

Thanks!

Nathaniel

[tehneXus]

Hi,
try to set the following at the beginning of your macro:

Please Login or Register  to view this content.

and at the end:

Please Login or Register  to view this content.

for the performance:
1. Avoid using "Select" and "Selection.Copy", copy the range directly
2. If you need the values to be copied without formatting do sth like:

Please Login or Register  to view this content.

[Leith Ross]

FYI

Application.DisplayAlerts only applies to Excel and not Outlook. In Excel this will automatically choose the default button on the dialog displayed and click it. The Outlook Application object does not have an analog to this Excel function.