• 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"?
0
ouestque
Asked:
ouestque
  • 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

Get-Data.png
You can use Excel's Power Query to do this.

There's some information here on doing this with VBA.
From-Web.jpg
0
 
ouestqueAuthor Commented:
Thanks Roy!!!
0
 
Roy CoxGroup Finance ManagerCommented:
Pleased to help
0
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