efz
03-03-2010, 02:55 PM
Hello i would like your help with something that i have been searching for lots of time! I think its quite hard but you know better cause i am a complete newbie on vba!
Ok I have a list of nearly 5.000 ISBN that i want to match each line with a specific "text" found in a website. But lets take it from the beggining:
Given i got in A1
the url of the website that have this syntax:
http://bookshop.blackwell.co.uk/jsp/id/ISBN
http://bookshop.blackwell.co.uk/jsp/id/ISBN
http://bookshop.blackwell.co.uk/jsp/id/ISBN
http://bookshop.blackwell.co.uk/jsp/id/ISBN
http://bookshop.blackwell.co.uk/jsp/id/ISBN
http://bookshop.blackwell.co.uk/jsp/id/ISBN
ETC.
etc. and in B1 i want to take this information for each line:
for example for an ISBN: 9780385504225
I GOT IN A1 THE URL (NOTE: URL ISNT STORED AS HYPERLINK)
http://bookshop.blackwell.co.uk/jsp/id/9780385504225
AND IN CELL B1 I WANT THIS TEXT:
US title not currently available
Is there a way to spider this information through VBA and if itsnt possible
could i maybe use vba to download all these html files and then strip them down with another program?
thanks in advance
to show you exactly what i want to do I have attached an img
Ok I have a list of nearly 5.000 ISBN that i want to match each line with a specific "text" found in a website. But lets take it from the beggining:
Given i got in A1
the url of the website that have this syntax:
http://bookshop.blackwell.co.uk/jsp/id/ISBN
http://bookshop.blackwell.co.uk/jsp/id/ISBN
http://bookshop.blackwell.co.uk/jsp/id/ISBN
http://bookshop.blackwell.co.uk/jsp/id/ISBN
http://bookshop.blackwell.co.uk/jsp/id/ISBN
http://bookshop.blackwell.co.uk/jsp/id/ISBN
ETC.
etc. and in B1 i want to take this information for each line:
for example for an ISBN: 9780385504225
I GOT IN A1 THE URL (NOTE: URL ISNT STORED AS HYPERLINK)
http://bookshop.blackwell.co.uk/jsp/id/9780385504225
AND IN CELL B1 I WANT THIS TEXT:
US title not currently available
Is there a way to spider this information through VBA and if itsnt possible
could i maybe use vba to download all these html files and then strip them down with another program?
thanks in advance
to show you exactly what i want to do I have attached an img