ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   macro web (https://www.excelbanter.com/excel-programming/415477-macro-web.html)

Ranjit kurian

macro web
 
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

macro web
 
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.




Ranjit kurian

macro web
 
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.





Tim Williams

macro web
 
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.








All times are GMT +1. The time now is 07:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com