![]() I did not see this kind of effect in Office 2010 or earlier versions. i don't understand fundamentally why office is (apparently) so intertwined that one app can adversely affect others. Nothing i have tried has eliminated the effect of Excel VBA on the other Office applications. This includes using "Excel." prefix (e.g., =False), leaving window maximized, using "(ThisWorkbook.Name).WindowState =xlMinimized, and so forth. 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. 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. In my VBA code i use typical speed-up techniques: application.windowstate=xlMinimized, use manual calculations, and turn screen updating off. Interestingly PowerPoint does not appear affected. Since the 2013 upgrade, when running Excel VBA code, other Office 2013 programs (e.g., Word, Outlook) become non-responsive to mouse or keyboard input until the VBA code completes. ![]() I have pre-existing code that imports CSV files, performs calculations, and updates graphs. Our company upgraded to office 2013 about 6 months ago.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |