OLE automation Internet explorer

[Fuga]

Hi.

Normally I use the ldownload function to retrieve html source from the web, but I seem to run into problems when the page is a secure page (i e you have to log in). Even if you´re logged in, the ldownload doesn´t seem to get the data that is there.

If I´m wrong on this I would greatly appreciate if someone could tell me what I´m doing wrong.

Now if I´m right, I want to use OLE to control Internet explorer, but I need some basic help. From ms kb, I got so that I can navigate to a page, but how do I save the source as a text file? I can´t find it in the object browser, and no "suggestions" comes up when I type in the moduel window.

Thank you.


Fuga.

Sub test()
      Dim Explorer As Object

      Set Explorer = CreateObject("InternetExplorer.Application")
      Explorer.Navigate "http://www.microsoft.com"
      Explorer.Visible = True
      ***here´s where I need help***

End Sub

 

[pckranz]

Which reference do you use to declare an internet explorer object?

 

[darbid]

does this help you

http://www.access-programmers.co.uk/forums/showthread.php?t=176968

 

[pckranz]

Yes, that pretty much does it. Thanks.