How to copy a web page in Excel using VBA

[Iyyappan]

Attempts to code, in VBA, a means of copying a web page onto an Excel sheet have been frustrating and inconclusive. When I apply the "QueryTables.Add" approach using the URL, I get a partial result but it does not include the data I wish to capture - just static data. If I use the "FollowHyperlink" approach, Internet Explorer is called and the web page is displayed but I cannot see how to code in VBA, "SellectAll" and "Copy" so that I can then "Paste" to the Excel sheet. I have tried this approach in a manual manner using a list of Hyperlinks and calling each Hyperlink, copying the web page and pasting onto individual spreadsheets. Can this be achieved using VBA.

[Panop]

You can do that with two commands. That is // SelectAll and // Copy selection. Or else you can simply import the data inside the sheet. For that click on DATA > Import external data > New Web query.

[Go!pee]

Go on google and search for the codes. There are many sites which gives you reference code for vba to pull the entire website inside a excel sheet. There will be some code which will work on the base of content you are trying to copy.