iliace
Well-known Member
- Joined
- Jan 15, 2008
- Messages
- 3,562
- Office Version
- 365
- Platform
- Windows
I'm working on a macro that uses Internet Explorer (version 7) to open a search page and save the links that come up in a spreadsheet. I don't have a problem with the Excel portion of the thing, but I'm having difficulty with IE.
This is the preudo-code of what I have working so far:
In (much) older versions of Internet Explorer, you could code something like this:
which would return a collection of URLs on the active page. In VBA, however, I get a "Method Document of object IWebBrowser2 failed" error. And I don't really know of another way to do this.
Any suggestions?
This is the preudo-code of what I have working so far:
Code:
Dim obj As Object
Set obj = CreateObject("InternetExplorer.Application")
obj.navigate("http://www.url.com")In (much) older versions of Internet Explorer, you could code something like this:
Code:
obj.Document.Linkswhich would return a collection of URLs on the active page. In VBA, however, I get a "Method Document of object IWebBrowser2 failed" error. And I don't really know of another way to do this.
Any suggestions?
