PureBluff
Board Regular
- Joined
- Apr 4, 2014
- Messages
- 174
- Office Version
- 2016
- Platform
- Windows
- Mobile
Hi all,
I'm trying to scrape data from a webpage, I require 4 fields, 2 of which I've been able to retrieve but the other 2 allude me.
It's not a fixed URL, but this URL is already being retrieved from IE after a redirect, so for this example, I will use:
I wish to obtain the title:
Microprint P2010 No Clean, Lead Free Solder Paste, 15-32um, 250g Pot - MICROPRINT P2010 15-32UM, 250G
and the Manufacturer Part Number
MICROPRINT P2010 15-32UM, 250G
I have been using getelementbyID for the Product Overview/Product Information, which has worked fine, but the other text fields don't appear to work (I looked at the Xpath and it errors on Object required in VBA)
Any pointers?
Thanks
I'm trying to scrape data from a webpage, I require 4 fields, 2 of which I've been able to retrieve but the other 2 allude me.
It's not a fixed URL, but this URL is already being retrieved from IE after a redirect, so for this example, I will use:
I wish to obtain the title:
Microprint P2010 No Clean, Lead Free Solder Paste, 15-32um, 250g Pot - MICROPRINT P2010 15-32UM, 250G
and the Manufacturer Part Number
MICROPRINT P2010 15-32UM, 250G
I have been using getelementbyID for the Product Overview/Product Information, which has worked fine, but the other text fields don't appear to work (I looked at the Xpath and it errors on Object required in VBA)
Code:
strData = objHTML.getElementById("pdpSection_FAndB").innerTextAny pointers?
Thanks
