+ Reply to Thread
Results 1 to 2 of 2

improve performance

  1. #1
    Registered User
    Join Date
    MS-Off Ver
    Excel 2003

    improve performance

    I wrote a vba program that looks for keywords that are in a website. The keywords are stored in an excel file. The vba program retrieves each keyword using the cell method and then searches for that keyword in a website. Currently the vba program takes about 6 seconds to go through 400 keywords. Is a way to make the search faster?

    Would it makes a different if I load all the keywords in the excel file to RAM before doing the search? I'd like the search time to be about 1 second for 10,000 keywords.

    Also, my cpu usage is only about 30% during search process and I have an I5 processor. Is there a way to decerase the search time by telling vba to utilize more cpu time?
    Last edited by david90; 03-27-2013 at 07:44 PM.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365

    Re: improve performance

    Difficult to assess without seeing the code.

    However, I would expect it has more to do with the speed of your Internet connection and the responsiveness of the web site.

    Regards, TMS
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1