Please help me pull data from this website..
Please Login or Register to view this content.
Please help me pull data from this website..
Please Login or Register to view this content.
This site is not set up using HTML Tables.
I would suggest using some other method to get the data from the website.
Hello captaincrazzy,
Although this web page has 5 HTML tables, there is also other information in the report that needs to be included.
The attached workbook contains the macros shown below. These return the report data from the web page in a format very similar to the original. Comments have been added to explain the code's function.
There is button on the worksheet to call the macro GetReport. The empty columns on the worksheet have been hidden to make the report easier to read.
Module1 Macros
Please Login or Register to view this content.
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 Star below the post.3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks