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.
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.
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
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
- 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