![]() ![]() In my VBA code i use typical speed-up techniques: application.windowstate=xlMinimized, use manual calculations, and turn screen updating off. I had come across one page in stack overflow ( Application.Screenupdating = false affects all of office) that indicated screen updating set to false was a potential problem. I tried following the suggestions from that link and numerous others to modify my code so Word and Outlook are still functional while the macros are running. This includes using "Excel." prefix (e.g., =False), leaving window maximized, using "(ThisWorkbook.Name).WindowState =xlMinimized, and so forth. Nothing i have tried has eliminated the effect of Excel VBA on the other Office applications. i don't understand fundamentally why office is (apparently) so intertwined that one app can adversely affect others. I did not see this kind of effect in Office 2010 or earlier versions.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |