Results 1 to 10 of 11

Thread: webquery macro navigating through website with drop down menus

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Seeker sonny.thind's Avatar
    Join Date
    Aug 2011
    Location
    London, Ontario
    Posts
    7
    Articles
    0

    webquery macro navigating through website with drop down menus

    I am trying to write a web query through a secure website (cannot provide the log in data) "https://services.cuberoute.com/gcdp/html/home"
    which enables me to get info from different agencies on different dates. But I am not able to find any Macro which can
    1) get past the log in screen.
    2) select a drop down menu for the agency I need
    3) select a date from the calendar available and then download the table into excel
    see attached
    can someone provide me with a reference where I can find this ? I am using chrome and Internet Explorer.
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	Presentation1.jpg 
Views:	382 
Size:	19.4 KB 
ID:	216  

Posting Permissions

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