macro web

[Ranjit kurian]

Hi

I would like to create a excel macro, which should open the web link (http),
and it should type the username and password and select each options.

Could someone guide me on it, or if you have any related documents/website
to refer will be very needful.

 

[Tim Williams]

http://www.codeforexcelandoutlook.com/AutomateInetExplorer.html

Tim

 

[Ranjit kurian]

Hi Tim

thanks for the link, can u pls tell me where should i give my username and
password to open the web and iam not able to see that the web is opened when
i run the macro.

Set UserN = appIE.Document.getElementsByName("username")

 

[Tim Williams]

You'll have to adjust the code to fit the page you're accessing.
Without the HTML source for the login fields I can't make any suggestions.

Tim