Using Excel VB to control Internet

Hi

Does anyone know of a way that VB can be used to explore the internet. For example using VB to open Google and search for "Excel Help".

I've noticed the term Internet Transfer Control floating around but can't seem to find anything of much use.

If anyone has any suggestions I would be much appreciated.

Cheers
Crispie38

Hello Crispie38,

This macro will launch IE and open Google, and searches for "Excel Help". You can change the search in the code marked in blue. However, the code is specific to the Google search page, and will only run with Google. You must first set a reference in Visual Basic to Microsoft Internet Controls for this code to run.

1. Open your workbook and then press ALT+F11 to open the VBE.
2. Press ALT+T followed by the Enter key.
3. Scroll down the list until you find Microsoft Internet Controls.
4. Press the Space bar to select it, and press Enter

Please Login or Register  to view this content.

Adding the Macro
1. Copy the macro above pressing the keys CTRL+C
2. Open your workbook
3. Right Click on any Sheet's tab
4. Left Click on View Code in the pop up menu
5. Press the keys ALT+I to activate the Insert menu
6. Press M to insert a Standard Module
7. Paste the code by pressing the keys CTRL+V
8. Make any custom changes you need to the macro
9. Save the Macro by pressing the keys CTRL+S

Sincerely,
Leith Ross

Hi Lieth Ross

That's fantastic, one small problem though, the last piece of your coding you switch from IEapp to just IE, I changed the first instance and it works fine however in the second instance it does not like IEap or IEdoc, could you let me know what I need to do to change this.

Please Login or Register  to view this content.

Thanks
Crispie38

Also, is it easy to change the code for other websites? How do you find out that the search button is "btnG" or the search box is "q"??

Hello Crispie38,

My apologies for the typos. To change the code you need to use another browser supports viewing the document source page. To pick out the relevant parts in the code, you need to understand HTML.

Here is the HTML code from Google's page...

Please Login or Register  to view this content.

Here is the correct code

Please Login or Register  to view this content.

Sincerely,
Leith Ross

I want to click on a link in the google page like iGoogle, Maps or something else using VBA,
Please some one help me on this.