Web Scraping Error

markusreyes2907

New Member
Joined
Jul 14, 2020
Messages
32
Office Version
  1. 2013
Platform
  1. Windows
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
 

Some videos you may like

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

Watch MrExcel Video

Forum statistics

Threads
1,118,860
Messages
5,574,701
Members
412,612
Latest member
Shotokan
Top