• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to select Mousehover / over menu item from webpage

Nitesh Khot

Nitesh Khot

Member
Hi..,

I am unable to get any VBA code to click on "KINDLE" option on webpage. Which is a mouse over/hover menu.
upload_2015-5-8_20-33-42.png


Below is the HTML code for the same:-


upload_2015-5-8_20-34-45.png



upload_2015-5-8_20-33-42.png upload_2015-5-8_20-34-45.png upload_2015-5-8_20-33-42.png upload_2015-5-8_20-34-45.png
 
It's a workaround...

Code: 
Sub test()

Dim IEApp As Object

Set IEApp = CreateObject("InternetExplorer.Application")

IEApp.Navigate ("http://www.amazon.in")

Application.Wait Now + TimeValue("00:00:03")

IEApp.Visible = True

Set Link = IEApp.Document.getElementById("nav-shop-all-button")
Link.Click

End Sub

or

Code: 
Sub test2()

Dim IEApp As Object

Set IEApp = CreateObject("InternetExplorer.Application")

IEApp.Navigate ("http://www.amazon.in/gp/site-directory/ref=nav_sad")

IEApp.Visible = True

End Sub
 
Hi...deepak...thank for prompt response and its working very nice.....

but i have another internal portal in my office and i want to experiment the same is not working. below is the code for the same. Also i cant share you portal url because this will open only in office not outside. Below is the code of HTML for the same and I want to move mouse first on "UTILITY" menu then down "BACK UP" menu then move to right "EXPORT TO EXCEL (DATA BACKUP").

This site is session/cookies enable site if you refresh webpage or navigate another url then auto logout from session.

upload_2015-5-9_9-2-5.png



Attached file for HTML code of the same page.
 

Attachments

  • html code.txt
    2.1 KB · Views: 4
You must log in or register to reply here.
Back
Top