VBA code to retrieve information from sub-pages if they exist

**xlhelp7** · 03-10-2017, 01:48 AM

Hello everyone!
I've searched for several hours with no luck.What I'd like to do is this:I have a vba code with the help of this code i am able to get data from web page but i am able to get data from one page only if there is more than one page then i want navigate to next page if they exist move to the next page and get data and repeat.

Please Login or Register  to view this content.

My vba code

Please Login or Register  to view this content.

**MarvinP** · 03-10-2017, 01:50 AM

Hi xlhelp,

The function you are seeking is in Power Query. You can download it as an Excel add-in.

https://www.mattmasson.com/2014/11/i...g-power-query/

**xlhelp7** · 03-10-2017, 07:20 AM

Hi MarvinP,

Thank you for your reply - much appreciated.

what i am trying is possible by doc.getElementsByClassName?

Regards,

Xlhelp7

VBA code to retrieve information from sub-pages if they exist

LinkBack

Thread Tools

Rate This Thread

Display

VBA code to retrieve information from sub-pages if they exist

Re: VBA code to retrieve information from sub-pages if they exist

Re: VBA code to retrieve information from sub-pages if they exist

Thread Information

Users Browsing this Thread

Similar Threads

Need vba code to print specific pages or all pages in a multipage UserForm

To retrieve certain information from one cell to next

VBA code to retrieve information from a spreadsheet onto a userform

[SOLVED] Check First IF Sheet Is Exist With The Name Of Cell K7 If exist Then run the code

Need Help with VBA code to retrieve information from a range of cells

retrieve information

how to retrieve data from password protected web pages?

Bookmarks

Bookmarks

Posting Permissions