ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Web page Log in Page (https://www.excelbanter.com/excel-programming/435646-web-page-log-page.html)

Vikram Dhemare

Web page Log in Page
 
On regular basis, i'm importing the web page data in excel by using macro. If
i do not refresh the import button for certain time, the page is redirected
to login page.
I want to send the keys like user ID & pwd to login page & go ahead to the
desired page from where I am getting the data.
Is there any way to log in & go ahead on button click.

--
Thanks,
Vikram P. Dhemare

joel[_152_]

Web page Log in Page
 

You will find the loginin object will equal nothing if your are already
login. I assume you are lookin for a form (or equivalent)

'get login object
set obj = ie.document .............
if not obj is nothing 'found the login object so login

'add your code here to login in, otherwise skip this code

end if


--
joel
------------------------------------------------------------------------
joel's Profile: http://www.thecodecage.com/forumz/member.php?userid=229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=149816



All times are GMT +1. The time now is 10:16 PM.

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