Hello,
I would like to create a VBA/macro that automatically updates my spreadsheet with the proposed lineups when the spreadsheet is refreshed. I've tried using the power query editor without any success retrieving the data from the website. The power query editor gave me options for Document (Kind = element, name = HTML , Children = table, and text = null) and table 0, which shows a table for social media. Can someone help me with a VBA to grab each applicable table?
Thank you
Hello dewonw,
The lack of detailed information makes it impossible to accurately address your concerns. Can you post a copy of your workbook for review?
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
I've attached the example. I'm trying to extract the data from https://www.fantasylabs.com/mlb/lineups/ via excel in order to compile the data in column B in the attachment. As a workaround, I'm using a data parser which is adding many steps to the process.
Excel version 365
Last edited by dewonw; 07-08-2018 at 07:11 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks