+ Reply to Thread
Results 1 to 2 of 2

Opening a dynamic Hyperlink in IE using macro

  1. #1
    Registered User
    Join Date
    12-01-2012
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    1

    Opening a dynamic Hyperlink in IE using macro

    Hi,
    I have a column "search" in my excel sheet.
    I am trying to implement a macro that will search the active cell on google.com

    eg. if books is selected

    its will open google.com/search=books in IE

    could someone help me

    I have the following code, how can i modify it to use with active cell

    Dim ie As Object
    Set ie = CreateObject("Internetexplorer.Application")
    ie.Visible = True
    ie.Navigate "www.google.com"

  2. #2
    Valued Forum Contributor
    Join Date
    11-15-2008
    Location
    ph
    MS-Off Ver
    2007/2010/2016
    Posts
    479

    Re: Opening a dynamic Hyperlink in IE using macro

    Hi -

    Go into www.google.com and type books in the search field.
    What did you see in the address bar?
    Type another search term?what did you see?
    so in you navigate address, copy that url and change the parameter based on the cell value

    Regards,
    Event

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1