I need to take the filename from a column in excel, make it part of a url, go to that url, get the title of the page and bring that info back to excel and put it next to the original filename. I need to do this for a list that has 1000s of filenames in it. Here's an example:
the list has filenames like this:
x123
y1234
z12
For the first one, I'd put that filename at the end of a url like this:
http:\\www.example.com\x123.htm
I'd go to that url and when the page opens, I need to get the title of the page, which would be:
"x123-08 These Are Extra Words in the Title that I don't Need but I Can Deal With Later"
The part I am really trying to get is the x123-08 but I would settle for the whole title if necessary and remove the rest in a different step.
I would like to copy this back to my excel file in the cell next to the original, like this:
x123 ____ x123-08
y1234
z12
Then I need to go on to y1234 and do the same process.
So, I know each step that I need to do. I just don't know how to do some of them...like variables, I'm not sure how to move down the list and do the process for each one.
You have no idea how much I would appreciate any help with this.
Thanks in advance!