Webscraping using VBA

Matt Miller
Matt Miller used Ask the Experts™
on
I've been trying to web scrape data from http://www.global-rates.com/interest-rates/libor/american-dollar/american-dollar.aspx  for excel but I've never done it before.  

I've tried using excel's from web function but it doesn't return anything.

Would anyone have any suggestions on how to use VBA?

Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Excel & VBA Expert
Most Valuable Expert 2018
Awarded 2015
Commented:
I used Power Query to get the table from web page. Can you see the table on sheet2?
WebScraping.xlsx

Author

Commented:
Thank you this is absolutely what I needed.

Author

Commented:
Perfect.  Thank you.
Subodh Tiwari (Neeraj)Excel & VBA Expert
Most Valuable Expert 2018
Awarded 2015

Commented:
You're welcome!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial