Hi all,
I would like to import an entire page "http://www.wunderground.com/history/airport/coventry/2014/1/19/WeeklyHistory.html?req_city=NA&req_state=NA&req_statename=NA&MR=1" into the spreadsheet. In particular I need the last table.
I tried web query, but I want to be able to alter the html code, that's why Web Query didn't work. Any help would be massively appreciated.
VBA so far
Please Login or Register to view this content.
Please click the * Add Reputation if this helps
If solved remember to mark Thread as solved
"I'm glad to help and this is not meant to sound smart, but either you have super-human vision to see all those controls cleared one by one with the code I posted, or your computer is really slow."
Hi,
heres a way to import the data required.
As Blokeman says you should not cross post as you will waste peoples time if you already get an answer on other sites.
But as there are no replies to the other posts here is my one.
Regards
Sean
Please add to my reputation if you think i helped (click on the star below the post)
Mark threads as "Solved" if you have your answer (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [code]
Please supply a workbook containing example Data: It makes its easier to answer your problem & saves time!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks