Looping An Array (HTML Source Page) To Separate Columns

[superdesi]

Thanks to everyone in advance.

Original Issue: I have a sheet with 50 urls that point to a sharepoint aspx page where I need to extract email addresses (which are not part of any element and are enclosed in a json file.)

The source page for every url has 1350 lines and I need the contents of line 1347. The entire source does not fit into a cell, thus I had to modify the code below so that it posts the entire source to sheet2 leaves a row and repeats for all urls.

Instead of continuing on column A, I want it to start posting it in columns across, which will make it easier to use a regex function to filter out the email addresses I need.

The best approach would be to include the regex function within the sub so that it could write the regexed string to the adjacent cell of the url..........before it loops to the next url.

Hope I didn't confuse anyone.

Please Login or Register  to view this content.