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

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.