Hi All,
I'm a VBA beginner I would like to copy text from a webpage that is not in a table. The text is basically a daily post from this calendar year.
The individual page URLs have the date in the URL. For example, these would be the pages from the first 4 days of March:
webpage.com/dailypost/2012/03/01?version=xyz
webpage.com/dailypost/2012/03/02?version=xyz
webpage.com/dailypost/2012/03/03?version=xyz
webpage.com/dailypost/2012/03/04?version=xyz
There is other text on the daily post webpage, but the text I would like to copy always has text like “Daily Post Starts Here” right before and always has the same “Daily Post Ends Here” at the end. I would like to retain the HTML formatting of the text if possible?
Would creating 365 cells with each unique URL work, and then loop through each one?
I'm a VBA beginner I would like to copy text from a webpage that is not in a table. The text is basically a daily post from this calendar year.
The individual page URLs have the date in the URL. For example, these would be the pages from the first 4 days of March:
webpage.com/dailypost/2012/03/01?version=xyz
webpage.com/dailypost/2012/03/02?version=xyz
webpage.com/dailypost/2012/03/03?version=xyz
webpage.com/dailypost/2012/03/04?version=xyz
There is other text on the daily post webpage, but the text I would like to copy always has text like “Daily Post Starts Here” right before and always has the same “Daily Post Ends Here” at the end. I would like to retain the HTML formatting of the text if possible?
Would creating 365 cells with each unique URL work, and then loop through each one?
