+ Reply to Thread
Results 1 to 2 of 2

VBA to Automate (Open web page, Select Dropdown, click button, fetch data in excel)

  1. #1
    Registered User
    Join Date
    10-22-2015
    Location
    Mumbai
    MS-Off Ver
    mac 2016
    Posts
    1

    VBA to Automate (Open web page, Select Dropdown, click button, fetch data in excel)

    Hi All,

    I am trying to fetch all NAVs in a sheet from http://www.amfiindia.com/net-asset-value

    My goal is to select 'All' from 'Select Mutual Fund House' dropdown and click 'Get NAV'. and Fetch all data in a excel sheet.

    Hence, I need a macro which do following action.
    1. Go to http://www.amfiindia.com/net-asset-value
    2. Select 'ALL' from 'Select Mutual Fund House' dropdown.
    3. Click 'Get NAV'
    4. Fetch all data in excel sheet.

    Thanks in advance.

    Cheers,
    Jack

  2. #2
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Re: VBA to Automate (Open web page, Select Dropdown, click button, fetch data in excel)


    Hi !

    After click Get NAV just click on the Excel icon and it's done, no need a code !

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Use VBA to Automate Actions on Webpage (Open web page, Select Dropdown, click button)
    By ravikiran in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-03-2015, 07:29 AM
  2. [SOLVED] Click the button and open the file in a separate Excel window
    By LewisM in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-19-2014, 11:04 AM
  3. Open outlook saved messaged from a folder through the click of a button in excel
    By chris2 in forum Outlook Programming / VBA / Macros
    Replies: 0
    Last Post: 09-20-2012, 11:06 AM
  4. Replies: 3
    Last Post: 06-05-2012, 04:36 AM
  5. How to open Excel files and click a button ?
    By bananas in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-02-2008, 11:28 AM
  6. fetch data from excel page
    By Mark in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-21-2006, 11:15 AM
  7. Automate a button click event
    By JD in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-08-2005, 08:05 PM

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