Very Hard Question

[Tony via AccessMonster.com]

I want to make a database that stores pictures of food from various websites.

What I want to do Is create a function that executes a google search for the
word "lobster" and retreives ALL images from ALL websites that return from
the search, maximum of 20 sites. Then it saves each image to a folder.

I'm wanting to create a menu. If the website has lobster on it, then it will
have other fine dining items as well.

Also, I only want it to save the picture if the file size is larger than 20KB,
as I only want images of higher resolution. (I'm gonna do a lot of
photoshoping to these images to make them appear more appetizing on a menu).
And I'm aware of copyright laws. I'm just doing this to put together a
sample menu, and then will manually select images I like, and take new
photographs of them.

Can this be done in VB?

Thank you

 

[John Nurick]

Very easy answer: yes.

Unless you're fluent in Google, VB/VBA, HTTP etc., however, it will
probably be quicker just to go take the photographs.

 

[Tony via AccessMonster.com]

John,

Thank you for response. Would you be interested in pointing me to the right
direction where I can get the code for this? I am very fluent in VBA. I
know I will need to instatiate a "InternetExplorer.Application"

Any help you could provide me to get started would be greatly appreciated. I
do have a good reason for wanting to automate this.

Thank you,
Tony

Very easy answer: yes.

Unless you're fluent in Google, VB/VBA, HTTP etc., however, it will
probably be quicker just to go take the photographs.

I want to make a database that stores pictures of food from various websites.

[quoted text clipped - 15 lines]

Thank you

 

[John Nurick]

I doubt whether it's a question of "getting the code" but of learning
enough to write it. It's not my field; I'd start with a web search for
"microsoft internet controls" and the "microsoft html object library"
and also study the documentation for these at http://msdn.microsoft.com.

No doubt you've already explored http://code.google.com/. The O'Reilly
Google Hacks book may be useful too.

John,

Thank you for response. Would you be interested in pointing me to the right
direction where I can get the code for this? I am very fluent in VBA. I
know I will need to instatiate a "InternetExplorer.Application"

Any help you could provide me to get started would be greatly appreciated. I
do have a good reason for wanting to automate this.

Thank you,
Tony

Very easy answer: yes.

Unless you're fluent in Google, VB/VBA, HTTP etc., however, it will
probably be quicker just to go take the photographs.

I want to make a database that stores pictures of food from various websites.

[quoted text clipped - 15 lines]

Thank you