Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

VBA running slow in Excel

Status
Not open for further replies.

Dukster131

Programmer
Apr 28, 2002
10
US
I am creating a VBA project in Excel for a company. It was working and loading fine and then suddenly whenever I tried to load the file or exit the file it was extremely slow (several minutes).

Is there a reason for this to happen.

The file is about 2.5 mb.

I have tried removing the modules and forms and saving the file and the importing the modules and forms, but this didn't seem to help

 
This is probably a long shot, but if you use Microsoft Outlook, look at thread181-257386. It is applicable to Excel as well.
Steve
 
Thanks for the idea. However, when I looked at Outlook nothing was checked for the journal.

George
 
George,
The other thing that is worth checking is that you dont have any anti virus software installed, which could slow down the loading (another long shot, but worth noting).
Steve
 
Steve,

I thought about that. I have Norton Antivirus and have tried disabling it and it still loads slow. It ran fine with Norton antivirus before I upgraded Office 2000. I don't know if upgrading Office 2000 had anything to do with the problem or not. I needed to upgrade because I was getting some weird errors when coding some email options.

It now takes two to three minutes (or longer) to load the spreadsheets from a template. When I use the custom forms I have created it takes 20 to 30 seconds for the information to be inserted onto the spreadsheet.

I am also using a VLookup on another Excel spreadsheet and it takes several minutes to establish the links before I can work with the spreadsheet.

George
 
George, two other things before I run out of ideas:

(a) Check out thread702-206410
(b) Any chance of trying to run the programs on another computer, so that you can compare.

Thats about all I can offer at present,
Good luck,
Steve
 
Steve,

I am becoming very suspicious of the Office 2000 updates. I have two computers and three operating systems. I updated on my laptop using Windows XP and it runs slow. I updated on my desktop Windows 2000 OS and it runs slow. I have not updated on my XP boot on my desktop and it runs fast. So I am thinking that they are doing something in the settings (probably for security) in the updates that make these files run slow.

George
 
On a stand alone machine my code works fine..
but on a network with win 2k,I have a problem with time hits when running code that manipulates text files via the "runsql" statement....If I change the file format, I.E. export to xls worksheet or access table, it's fine but exporting/importing to or from csv/text puts the big anchor on.

:-(
 
I have timed this event and it takes 4 1/2 minutes to load the initial files and another 4.5 minutes to load the VLOOKUP connections. That means it takes almost 10 minutes to load the program. This is in contrast to about 5 seconds before the Office 2000 update.

George
 
George,

When you say Office 2000 updates, is there a service pack, or do you mean stuff thats delivered automatically over the internet. I'm running Access97 and Office 2000 on XP Pro, and have no performance problem (version 9.0.2720).
Sounds almost like your computer has been configured to "look for something", and is timing out and then continuing ??

Good luck,
Steve
 
Steve,

It was the service pack 1 and 2 that I upgraded with. After upgrading, I began having the problems. My excel now says it is 9.0.4402 SR1. Which is interesting because I have updated it with SP 2.

These updates are located on Microsoft Office web site.

George
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top