I am trying to find a piece of code that will allow data to be retrieved from the source of a HTML page and be placed in a column in excel.
I have a spreadsheet that cointains the url of the web page, and have the code to view the source, however, what i can't do is extract data within a specific span tag.
i.e. i want to be able to go to a web address in colum a (www.awebsite.com) and extract data between <span class = "image"> and</span> tags and paste this value into the colum B. The reason is i have a large amount of products to maintain and need to ensure they always have an image as the image paths change regularly. Can anyone help?
Bookmarks