I am having an issue when web scraping within VBA. My macro will work until I use certain properties within the code (e.g. nextElementSibling) and then my code will suddenly produce a Run-time error '-2147467259 (80004005)': Unspecified error. When that comes up it says there is an error in my code in the ie.Visible = True line that had previously worked many times before. From there I can't seem to reset the macro and I have to abandon the whole thing and create a new one. Anyone know why this is happening, or how I can fix it so I don't have to create a whole new module. Thanks, Markus

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Web Scraping Error

Thread starter markusreyes2907
Start date Sep 22, 2020

markusreyes2907

New Member

Sep 22, 2020

I am having an issue when web scraping within VBA. My macro will work until I use certain properties within the code (e.g. nextElementSibling) and then my code will suddenly produce a Run-time error '-2147467259 (80004005)': Unspecified error. When that comes up it says there is an error in my code in the

VBA Code:

ie.Visible = True

line that had previously worked many times before. From there I can't seem to reset the macro and I have to abandon the whole thing and create a new one. Anyone know why this is happening, or how I can fix it so I don't have to create a whole new module.

Thanks,

Markus