Slow-Opening Excel VBA Application - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Welcome to the new platform of Programmer's 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 its 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

joeconti55joeconti55 Posts: 1Member
[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!


Comments

  • PavlinIIPavlinII Posts: 404Member
    : [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!
    :
    :
    :
    You can find your Temp dir in [green]?:Documents and SettingsNameOfUserLocal SettingsTemp[/green].... and if it isn't only office, defragment your disk! [gray]It maight make your system faster +/-30% (in extreme cases)[/gray] ;-)

    PavlinII
Sign In or Register to comment.