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.

http://www.codeforexcelandoutlook.co...tExplorer.html

Tim


"Ranjit kurian" wrote in message
...
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.

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" wrote:

http://www.codeforexcelandoutlook.co...tExplorer.html

Tim


"Ranjit kurian" wrote in message
...
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.

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

"Ranjit kurian" wrote in message
...
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" wrote:

http://www.codeforexcelandoutlook.co...tExplorer.html

Tim


"Ranjit kurian" wrote in message
...
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.