+ Reply to Thread
Results 1 to 6 of 6

Download a table from a website coded with angular using vba

  1. #1
    Registered User
    Join Date
    02-29-2016
    Location
    Israel
    MS-Off Ver
    2007
    Posts
    27

    Download a table from a website coded with angular using vba

    Hi all,

    I would like to download a table from a website ( I can't send the link as it is from my organization - NDA and stuff).
    In the past, I used xml to get the table as I knew which ID to grab but recently, the webiste underwent some changes and the IT recoded with angular. All the normal ID's have changed and when I try and scrape the table using the class, it returns the whole row as once cell and pastes it in excel vertically. I would prefer not to have to make modifications in excel itself to organize the data as there are thousands of rows to the table.

    Any ideas?

    Thanks!!

  2. #2
    Banned User!
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    2,014

    Re: Download a table from a website coded with angular using vba

    well, first of all, angular is not HTML. is this what you're dealing with?

    https://material.angular.io/components/table/overview

    or do you know? please post the code that previously worked.

  3. #3
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: Download a table from a website coded with angular using vba

    Joseph, are you still using Excel 2007 or have you updated. If you have updated, please modify your profile to reflect your current version. This will allow others to determine if they can assist with more up to date functionality within newer versions of Excel.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  4. #4
    Registered User
    Join Date
    08-17-2022
    Location
    United States
    MS-Off Ver
    MS Office 2007
    Posts
    1

    Re: Download a table from a website coded with angular using vba

    Examine the html source code, and find the url where you want to download the table. You can use the following code to parse the webpage and read the url (mmcgbl.com/angular-development/) of the table:

  5. #5
    Forum Contributor
    Join Date
    02-25-2022
    Location
    Dallas, Texas
    MS-Off Ver
    Office 365
    Posts
    174

    Re: Download a table from a website coded with angular using vba

    You can use selenium to download a table be specifying the table number. You need to use XPath to select table element. Update Chromedriver to your version of chrome.
    Attached Files Attached Files
    Last edited by mogul; 08-18-2022 at 07:24 AM.

  6. #6
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: Download a table from a website coded with angular using vba

    @samonrichard and @mogul

    This post was from December 2020, a year and half ago. I doubt very much that the OP is still looking for a solution. You may want to review more recent requests for help and focus in that direction.

+ 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. Data download from website
    By vilasc in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-28-2019, 12:56 AM
  2. Download XLS file from a form website ASP
    By Yensang in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-17-2015, 06:21 PM
  3. Download CSV File from Website
    By chinraj in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-19-2014, 09:09 AM
  4. file download from website
    By dgkindy in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-04-2009, 10:39 AM
  5. download info from website
    By sashun in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-22-2007, 10:42 AM
  6. Download excel doc from website, can this be done?
    By Billznik in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-09-2006, 03:29 PM
  7. [SOLVED] Automatic log on to website and download report using VBA
    By Hari in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-13-2006, 03:10 AM

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