Automatically click on link in Internet Explorer using VBA

**mistermetaj** · 12-13-2014, 02:34 PM

Hi Everyone,

My question is really simple. I want to use VBA to open explorer, navigate to google.com and click on the "Gmail" link in the upper right corner.

I can open explorer and navigate to google, however when I inspect the element for the Gmail link, it does not have an ID. I tried to work into it to no avail using parent IDs and class names. I honestly didn't know what I was doing, but I'll pose the code below anyway. THANKS FOR THE HELP!

Sub OpenExplorer()

Dim IE As Object
Set IE = CreateObject("InternetExplorer.Application")
Dim link As Object

IE.navigate "http://www.google.com"
IE.Visible = True

While IE.BusyDoEvents
Wend

'This is where I attempted to find the link:
IE.document.getElementById("gb").getElementsByClassName("gb_Ub gb_Rc").getElementsByClassName("gb_7 gb_Rc gb_h gb_Qc gb_Uc").getElementsByClassName("gb_Cc gb_h gb_Rc gb_Kc").getElementsByClassName("gb_g gb_h").getElementsByClassName("gb_f").Click

End Sub

**martindwilson** · 12-13-2014, 02:49 PM

WHY NOT NAVIGATE TO
"https://accounts.google.com/ServiceLogin?continue=http%3A%2F%2Fmail.google.com%2Fmail%2F%3Fpc%3Dtopnav-about-en&service=mail&dsh=8065733805618555414"

**mistermetaj** · 12-13-2014, 02:53 PM

Originally Posted by martindwilson

WHY NOT NAVIGATE TO
"https://accounts.google.com/ServiceLogin?continue=http%3A%2F%2Fmail.google.com%2Fmail%2F%3Fpc%3Dtopnav-about-en&service=mail&dsh=8065733805618555414"

I know I can navigate directly to the link. However, I am just using this Gmail question as a simple example since I know everyone has access to do it. My actual project is based on a different webpage where the navigable link changes.

**Winon** · 12-13-2014, 02:57 PM

Hello mistermetaj,

Post deleted.

**mistermetaj** · 12-13-2014, 03:01 PM

Originally Posted by Winon

Hello mistermetaj,

Congratulations on your first post, and a hearty welcome to now officially be considered as a "family member".

However, your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE] [/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

No hard feelings, o.k.

We all have to abide to the rules.

Regards.

Thanks. Fixed it.

**martindwilson** · 12-13-2014, 03:14 PM

asking the correct question would help! how are we supposed to guess that from the info provided?
to link to images you'd use
"https://www.google.co.uk/imghp?hl=en&tab=wi&ei=OpGMVK2pNezB7Aa1cQ&ved=0CAQQqi4oAg"
to link to mail
"https://mail.google.com/mail/?tab=wm"
well thats what i see when i inspect the elements

**mistermetaj** · 12-13-2014, 03:24 PM

Originally Posted by martindwilson

asking the correct question would help! how are we supposed to guess that from the info provided?
to link to images you'd use
"https://mail.google.com/mail/?tab=wm"
to link to mail
"https://mail.google.com/mail/?tab=wm"
well thats what i see when i inspect the elements

I think I need to be more clear with my question. I understand that I could put the links you are showing me in the part of my code that is

IE.navigate("...")

But that isn't my question. I need to program VBA such that it clicks on the 'Gmail' element through some form of code such as:

IE.document.getElementByID("...").click

where the ID of the Element is unique and is automatically clicked on. My problem is, and your post shows the HTML, there is no unique ID for the link, so I need to know if there is an alternative in VBA to identify the Element and click on it.

I appreciate the help, and hopefully I am making my question more clear.

Automatically click on link in Internet Explorer using VBA

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Automatically click on link in Internet Explorer using VBA

Re: Automatically click on link in Internet Explorer using VBA

Re: Automatically click on link in Internet Explorer using VBA

Re: Automatically click on link in Internet Explorer using VBA

Re: Automatically click on link in Internet Explorer using VBA

Re: Automatically click on link in Internet Explorer using VBA

Re: Automatically click on link in Internet Explorer using VBA

Thread Information

Users Browsing this Thread

Similar Threads

Macro to download a file by click a button on internet link

internet explorer control click

loop through a range and open internet explorer where link is valid

VBA to Automate the a click on the "Open,Save,Save As" Windows Internet Explorer Dialog

Internet Explorer Extraction on Click

Bookmarks

Bookmarks

Posting Permissions