+ Reply to Thread
Results 1 to 3 of 3

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
    MS-Off Ver
    MS Office 365
    Posts
    19,671

    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.

+ 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. 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