Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Excel VBA performance issue

  Asked By: Joao    Date: Mar 26    Category: MS Office    Views: 1113
  

I have a Excel spreadsheet which i connects to a website Bloomberg
and retrieves values from the website and put in on the spread
sheet. this had a VBA code written in order to accomplish this task.
It used to work fine. suddenly this has slow down. and it take more
and more time to refresh values on the spreadsheet from the website.

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Alexander Bouchard     Answered On: Mar 26

Take a look at cleaning out your temp files. I'll bet you are loaded
down with cached web pages. See:
http://www.mousetrax.com/maintain.html for specific things to do. Let
us know if this does not clear up your problems, though.

 
Didn't find what you were looking for? Find more on Excel VBA performance issue Or get search suggestion and latest updates.




Tagged: