Open IE with Excel and log into page

hy,

I am trying to open the Internet Explorer go to a specific HP and then to log in.

I managed to get to the HP with the following code:

Shell ":\Program Files\Internet Explorer\iexplore.exe https:\\www1.emidas.com/default.aps ",vbNormalFocus

Unfortunately, I am stuggeling with entring the username and the pw automatically.

Can anyone help me?

Thanks,

Hi RMF123 and welcome to the forum :)

Please be sure to read the posting guidelines (http://www.xtremevbtalk.com/faq.php?faq=evbf_faq#faq_evbf_rules).

Have a good read through this link - it should get you a long way towards your goal.

http://www.dailydoseofexcel.com/archives/2004/09/22/automating-internet-explorer/

HTH
Colin

Just to flesh out the last part of the example Colin linked to a little:

If you're using the Explorer to view HTML, the .Document property will return an object of type HTMLDocument. If you set a reference to the "Microsoft HTML Object Library" in addition to the one to "Microsoft Internet Controls" mentioned, you can then go to an early-binding declaration
Dim IeDoc As HTMLDocument

which will give you intellisense (and object browser entries) when dealing with the document tree - very useful, as the MSDN section on MSHTML is a bit of a mess. I'm not quite sure why the article says that it's impossible to link to it, it's right here (http://msdn.microsoft.com/en-us/library/aa741322(VS.85).aspx), but as it's organized by interface classes rather than object types, it does take quite a bit of getting used to. :rolleyes: