jeudi 25 juin 2015

Trying to get data from multiple web pages into excel

I am trying to pull a specific string of text from the following web page:

http://ift.tt/1BPeVDn

The 1504 represents year year month month and I want to decrease this number until 0504 (April 2005: http://ift.tt/1BPeTeS).

Rather than having to go through and copy/paste this string 120 times, I was wondering how to input this into VBA and have the code do this for me.

If you visit any of the links between 1504 and 0504, the string I am looking for is immediately following the first "$" and goes until the $ ends (9 characters).

Thank you in advance!




Aucun commentaire:

Enregistrer un commentaire