VBA Code for working with IE

[smikkelsen]

I have a somewhat strange question. I can't really find any info on this, so i'm not sure if its ever done, or even can be done.

I would like to launch a new instance of Internet explorer, and use DOM to manipulate the browser using VBA in my access database. Has anyone ever done anything remotely close to this, or knows if it is possible?

Just as a simple example, if I had an onclick event that launched IE and logged into a gmail account using dom. I have done this in other languages, I would just like to be able to incorporate it into my database.

Thanks

[ajetrumpet]

I never really understood the DOM thing, but I know what it stands for. In my humble opinion, just about the best article you can find on this stuff is right here: http://www.access-programmers.co.uk/...d.php?t=176968

[smikkelsen]

wow, this is actually exactly what I was talking about. Thank you so much for sending that link!

I haven't had a chance to try any of it yet, but I will try to post my results if it works out.

Thanks again.

[smikkelsen]

I successfully got my command button to open a new instance of IE, navigate to my login page, login, navigate to a specific page once logged in, and enter some data on that page and submit it.

Everything on that site you gave me is simple enough. I wasn't expecting the dom to be so simple to use in VBA, the only thing I had to do was go into the vba tools>reverences, and turn on microsoft internet controls (for those who would like to do this) becasue that website did not explain that.

One other helpful thing that is not on that website is for objects that do not have id's, but have names, you can use this:

ie.Document.getElementsByName("Email")(0).Value = user

that example finds the first control in the html with name=email, and then puts the contents of variable "user" in.

Hope that helps someone else out!

Thanks again for the great link, it got me on a really good start.