Welcome to the new platform of Programmers Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use it's exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.
Slow-Opening Excel VBA Application
[b][red]This message was edited by joeconti55 at 2003-10-10 6:16:39[/red][/b][hr]
Pertaining to an Excel 2000 VBA application: Sometimes the performance slows and the application opens very slowly or won't open at all. I learned that, in Windows 98, I could delete all .tmp and .emf files from the Windows Temp directory (there would sometimes be over 1,000 in this folder) and performance would be restored.
Now, I'm having the same performance slowing in Windows XP Professional. Thinking I would be able to use the same fix (clearing the Windows Temp folder), I was surprised to find no .tmp or .emf files in there. I did a search for these suspected culprits, but there don't seem to be significant numbers of them anywhere on the machine.
What could be going on here? What are the possible causes and fixes for this degraded performance. The application file takes about five minutes to open under XP Professional. Help!