I have an existing Excel spreadsheet that imports individual 'products' from a well known PC components website, the macro currently imports the entire page, pulls out the Product name, price, prod code, stock level and description. However, they have changed the design, again, and the price is no longer imported into Excel (Data, Import External Query, web query) I can see that the HTML source still contains the price, it also contains tags, and that the info I require is contained within the tags, which is where my knowledge of VBA stops!
I require code in VB that can be used directly inside Excel, that imports the html betweeen two tags, I also need to be able to adapt the code if the tag names change. Ideally I require the results as variables that can manipulated in the rest of my code. Importing the product picture would be a bonus!!
The attached file is a copy of a randomly selected product, the website that it is enquiring on has been changed to XXXX.