ultraviewer manipulatepacket error : 1 :object variable or with block variable not set

ie.('product-description-iframe').圜lassName('productDescriptionWrapper'). You need to go through the iframe before you can get to the content. If ie.document.readyState = 'complete' Then Exit DoĮdit: after actually looking at the page you're trying to scrape, it looks like the reason it's failing is because the content you're trying to get at is in an iframe. If ie.ReadyState = READYSTATE_COMPLETE Then So you really need to check for two events. (note that frames may still be loading and AJAX processing may still be occurring.) Document fully loaded: ie.document.readyState = 'complete' I tried to save the product description in a variable with productDesc ('product-description-iframe').圜lassName('productDescriptionWrapper').innerText, but I get Object does not support this property or method.If you set a default value, then you dont need to set. In addition to setting the type, the 'flavor' and 'exitcodes' variables also provide a default. But if it is passed from a var-file where Packer can interpret HCL properly it can be a slice or any supported type. At this point, you can access ie.document without causing an error, but the document has only started loading. When a variable is passed from the cli or environment and the variables type is not set, Packer will expect it to be a string. Browser connects to page: ie.ReadyState = READYSTATE_COMPLETE.This is my understanding of the timeline for loading a page with an IE control. I'm pretty sure your problem is being caused by attempting to access the document before it's completely loaded. Object variable or with block variable not set.Īny suggestion why my statement does not work? I am trying to get the product description by using productDesc = Docx.getElementsB圜lassName('productDescriptionWrapper')(0).innerText. ThisWorkbook.Worksheets(1).Range('D' & RcdNum) = price 'ThisWorkbook.Worksheets(1).Range('C' & RcdNum) = productDesc Exception: : VBA error 91 (Object variable or With block variable not set. ThisWorkbook.Worksheets(1).Range('B' & RcdNum) = productTitle This issue was submitted by the add-in's exception handler. Price = Docx.getElementById('priceblock_ourprice').innerText 'productDesc = Docx.getElementsB圜lassName('productDescriptionWrapper')(0).innerText ProductTitle = Docx.getElementById('productTitle').innerText WebURL = ThisWorkbook.Worksheets(1).Range('A' & RcdNum)ĭo Until Ie.ReadyState = READYSTATE_COMPLETE However, I would also like to have the product description.įor RcdNum = 2 To ThisWorkbook.Worksheets(1).Range('A65536').End(xlUp).Row I put the link into column A and get the other fields in the respective columns, f.ex.:

I am want to scrap from amazon some fields.Ītm I am using a link and my vba script returns me name and price.

Ultraviewer manipulatepacket error : 1 :object variable or with block variable not set