+ Reply to Thread
Results 1 to 1 of 1

Web scrapping through VBA from a particular cell of HTML table

  1. #1
    Registered User
    Join Date
    01-09-2020
    Location
    India
    MS-Off Ver
    2007
    Posts
    2

    Web scrapping through VBA from a particular cell of HTML table

    I have a VBA code (thanks to rorya for making it workable for me) for scraping web data from a web page. This VBA is working fine. Now the data is moved to another page with some more fields. Form fields i.e. Train no., Date and a Radio button 'Departure' required to be checked/filled for populating the desired table. Attachment 658797. I have tried to modify the code but unable to click the Display button as there is no ID. How to submit the form, please suggest.
    Further data from one cell (loco no.) is required to be copied in the Excel sheet/cell Attachment 658798. How to achieve the above goal, please help. The Excel sheet is attached herewith (which I am trying to modify but stuck at Radio button).
    Last edited by electcnl; 01-21-2020 at 07:54 AM.

+ 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. HTML Cell border in Table
    By Raghukumarn in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-10-2015, 12:38 PM
  2. VBA to Import HTML Table Locally Stored HTML file to excel
    By ermengard in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 01-09-2015, 10:48 AM
  3. Web Scrapping Help
    By Spyderz in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-04-2012, 12:33 PM
  4. count rows in a HTML table and add the value to a cell in Excel
    By hahnice in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 08-22-2012, 08:59 PM
  5. Tweaking VBA Code for HTML Table Cell Reading
    By ShannonLarson in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-07-2009, 05:08 PM
  6. Can Web Query retrieve a single HTML table cell?
    By Joe Francisco in forum Excel General
    Replies: 3
    Last Post: 04-25-2006, 01:25 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