Need to extract list of all video files on specific channel(user/owner) of Youtube

[LMORCB]

Using VBA in an Access 2013 DB, I'm trying to capture a list of all videos on Youtube that were posted by a specific user. I can get about 30 of them (whatever is listed on the user's page) on the first pass. User allows for several pages with "show more" button and the thumbnails show up - but View Page Source only shows the details for the first page. So is there a way to access the entire list of videos by a specified user?



thanks.

[JamesDeckert]

Sounds like you could screen scrape the webpage and then create a loop or recursion to go into each "show more" button

[Perceptus]

Be very careful with screen scrapes. Ive never heard of it being legal unless the data is yours to begin with. in which case, you could access the data in a more efficient manner.

[LMORCB]

Found answer. Need to programatically 1) scroll to bottom of page; 2) "click" the "more" button; 3) set focus on different app; 4) return to webpage; 5) scrape data. Seems the "view source" doesn't reset until focus is lost and regained. Thanks for input.