code that works fine in excel 2007 ie ver 7 not in excel 2010 ie ver 9

Please anyone able to provide some help, i'm at a real loss here.

It seems that Excel 2010 is not recognizing the Internet Explorer object for some reason, anyone know if this is a setting or reference that needs to altered/added?

I am still getting error at the ots.write (IE.document.documentelement.innerhtml) line. I'm using IE 9. This was working fine in IE 7. Any help is greatly appreciated.

Try this, avoid automating ie at all costs, it is extremely slow :

Please Login or Register  to view this content.

Originally Posted by ycg0311

I'm using IE 9......

me too, I use IE 9, no problems

Thanks!!!! the code works great. However how can i get the html code in the file as opposed to just the text of the webpage?

Im not in front of a computer now, but try changing inner text to innerhtml

got it. Thanks man!

Actually just write the responsetext to the file and skip the html doc

One other question regarding this how do i use this the MSXML2.XMLHTTP object to access websites that have a login and pwd?

that's a lot more complicated. The WinHTTP Request object (which is very similar to the xml object) allows you to pass credentials, however the site has to be configured properly to accept them.

It would be easier to automate ie.

for some reason when automating IE i'm to create the object and open the URL but for some reason cannot do anything with IE after that as i'm getting

Automation Error
The interface is unknown.

Is there a reference in Excel VBA that needs to be checked perhaps?

No, not if you can create the object.

Can you post the code you're using?

It taps out at the do loop for some reason

Please Login or Register  to view this content.

It taps out at the do loop for some reason

Please Login or Register  to view this content.