It is possible to modify this code to search for large images and to return the link of the first image. I tryed to modify the google link with the google image link but it doesent work
Please Login or Register to view this content.
It is possible to modify this code to search for large images and to return the link of the first image. I tryed to modify the google link with the google image link but it doesent work
Please Login or Register to view this content.
hi
check this code
Cheers!!Please Login or Register to view this content.
Hi,
My earlier code was not fetching first image, use this to fetch..
Requirements In Column A write name of object for which you want image search, In B column you will get URL of source image & in C column you will get Image matching size of your cell, you can re-size your C column to make your image bigger or smaller before running macro..
Cheers!!Please Login or Register to view this content.
Hi everyone, thank you very much for your help! the code is great but I get an error
I think the error is due to the format %33%A... of the fetched link: http%3A%2F%2Fweknowyourdreamz.com%2Fimages%2Fbaby%2Fbaby-02.jpg
can you help please?
Hello
When I run excilliot's code it says Compile Error: User-defined type not defined. And it is referring to the "Dim IE as InternetExplorer"
Alternatively you can remove that line and add following one if you are not sure about howto set references:
Cheers!!Please Login or Register to view this content.
Hello All (and thanks ExcelElliot).
Using ExcelElliot's code as is, I received a compile error (even after making sure that all references were set).
It would error out on the line:
After alot of digging, i discovered that the url passed to the variable "furl" was not getting fully translated into a usable url.....meaning that it contained many instances of "%2F" instead of a forward slash.Please Login or Register to view this content.
I was able to get his code running by adding the following lines of code that further translate the resultant image URL to remove any instances of %2F:
Please Login or Register to view this content.
i got error with this "can't get an insert method of picture class"
so,image doesn't come .
what do I do for this error?
Last edited by estone5; 08-03-2016 at 04:07 AM.
Hi, could anybody assist, i am adding Exelliots code above and i get runtime error 5 , invalid procedure call when i run the code?
when i add values to Column A nothing is happening
Any help would be great! Thanks
thegr812k welcome to the forum
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.
If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.
Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
im getting the same error.
Any help would be great!
wind your neck in, newbie! You posted a question phrased as a statement. If you want an answer, open your own thread - and take a few minutes to read our rules.
little lost getting a not declared error, anyone have a working workbook to follow?
Administrative Note:
Welcome to the forum.
We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.
Please see Forum Rule #4 about hijacking and start a new thread for your query.
If you are not familiar with how to start a new thread see the FAQ: How to start a new thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks