Hi Team,

 

I am also trying to do something of this sort.  However when I copied this
program in my excel VB Editor.  It is giving me error at the declaration
line of 'MyBrowser', system is not recognising SHDocVw.InternetExplorer

 

Can anyone help me to know how to open internet explorer from Excel and then
open a webpage into it.

 

Thanks & Regards

 

Ashkaran Badlani

 

 

-----Original Message-----
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Mike C
Sent: 13 March 2009 05:04
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Automatically paste contents of active cell into
Webpage Search box

 

 

Someone gave the the below macro (using Microsoft Internet Controls

via Code Editor > Tools > References) for taking the active cell in

Excel and then automatically placing it in a search box in a new

Explorer Webpage, and then in effect, hitting ENTER.

 

It works with the website provided, www.ebay.com. But I am trying to

change it to work with another website. I am trying to do it with

http://www.half.ebay.com/.

 

Does anyone know how I can change alter the below code, or even any

new code, to produce the same effect at http://www.half.ebay.com/

 

Sub Login_Website()

'Requires Reference to "Microsoft Internet Controls"

    'Declare Reference to InternetExplorer Object

    Dim MyBrowser As SHDocVw.InternetExplorer

    'Set Reference to InternetExplorer Object

    Set MyBrowser = New SHDocVw.InternetExplorer

        With MyBrowser

        'Make the Browser visible

            .Visible = True

            ' Open Ebay.com with Active Cell Value

            .Navigate "http://shop.ebay.com/?

_from=R40&_trksid=m38.l1313&_nkw=" _

                       & ActiveCell.Value & "&_sacat=See-All-

Categories"

        End With

 

End Sub

 

Any suggestions are deeply appreciated!

 



--~--~---------~--~----~------------~-------~--~----~
-------------------------------------------------------------------------------------
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-------------------------------------------------------------------------------------
-~----------~----~----~----~------~----~------~--~---

Reply via email to