Hello everyone!
I have this VBA code that I use to download the first image from google, from a cell that contains search keywords.
Problem is, most of the times it does not download all images and some times duplicates, expecially in the end.
Can you guys kindly see my code and iluminate me with some ideas to solve this issue?
Thank you in advance!
Please Login or Register to view this content.
Did anyone had a change to take a look? I'm still trying to fix this.
Yesterday I tried to use a timeout function but didn't work, or I didnt apply it well.
If someone has any news please let me know.
you should mention you need microsoft internet controls and microsoft html object library
and include whatever this function is
URLDecode()
if it downloads duplicates I guess it errors and " On Error Resume Next" is hiding that error. try seeing where it fails with out that.
You may want to reset your variables at the end of each loop.
If you want something done right... find a forum and ask an online expert.
Time flies like an arrow. Fruit flies like a banana.
I have the correct references.
The "On Error Resume Next" Is for, when excel doesnt find anything in google and cannot retrieve any links to register. In this way instead of stoping the code running, it continues.
Excel doesnt seem to handle the time out of internet explorer.
I still have no solution for this problem.
Last edited by ExNub; 06-25-2019 at 01:14 PM.
I have tried other fixes. Without Success.
I re-writed the code and tried other things, so excel can have a good timing to download the fotos but didn't work.
Anyone had a chance to have a look?
Hi !
Originally Posted by ExNub
Should we guess what is your last code ?!
Maybe you can try another web search engine …
The re-write ended up with the same results of the original that I provided.
The google engine is the most reliable for what I need. Considering that I already prospected other engines.
I understand this ain't a everyday easy problem to solve, so, I would glady accept realistic solutions.
As the Google engine is the one I met with most issues for this kind of need,
as it seems you have optimized your initial code so I won't waste any time to recreate
what you yet have done without seeing your last code, as …
Then all I can say is to apply a web search for your need.
Or maybe restart from a well known Google result for only an unique cell (so without a loop for a range)
in order to test at least if your code well works of course without On Error Resume Next …
Once it well works, search another cell when it fails in order to compare each Google webpage code.
Ok, I understand your logic, thank your for sharing, I will try what you sugested.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks