• Status: Solved
  • Priority: High
  • Security: Public
  • Views: 35
  • Last Modified:

Excel VBA: Copy Web Page text

What VBA do I need to copy all text on a single web page into a sheet titled "Sheet1"?
  • 2
1 Solution
Roy CoxGroup Finance ManagerCommented:
You can try importing data from a web site manually. From the Data Tab select the first Group on the right and follow the steps after clicking the From Web button

You can use Excel's Power Query to do this.

There's some information here on doing this with VBA.
ouestqueAuthor Commented:
Thanks Roy!!!
Roy CoxGroup Finance ManagerCommented:
Pleased to help
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now