The Web Design Group

... Making the Web accessible to all.

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
> Help with HTML/EXCEL integration, Using EXCEL to log on to a Web page
JGupte
post Jan 30 2019, 08:45 PM
Post #1





Group: Members
Posts: 1
Joined: 30-January 19
Member No.: 26,808



Hi All,

I am using Excel to drive a procedure (using VB) that logs me on to a web page, then downloads a file.

I have it running in foreground, using SendKeys to parse the password to the web page, but need it to run in background when the computer is locked at night as it is a lengthy job that impacts other users if run during the day.

I found the code I need to use

ie.Document.Forms(0).all("User").Value = "me"
ie.Document.Forms(0).all("Password").Value = "mypasssword"
ie.Document.Forms(0).submit

but this does not correspond to the HTML found on the web page.

Can anyone please give me the tag for the password (the Username and company name are given as part of the web page address).

This is the web page I am trying to log into.

http://www.teambinder.com/TeamBinder5/Logo...amp;tcCmpId=ALS

Any help would be appreciated.

JG
User is offlinePM
Go to the top of the page
Toggle Multi-post QuotingQuote Post
pandy
post Jan 31 2019, 06:44 AM
Post #2


Don't like donuts. Don't do MySpace.
********

Group: WDG Moderators
Posts: 18,449
Joined: 9-August 06
Member No.: 6



The name of the password field? It's 'txtPassword'. You can just view source.

CODE

<td nowrap="nowrap" class="Bold">
    Password</td>
<td>&nbsp;</td>
<td>
    <input name="txtPassword" type="password" maxlength="20" id="txtPassword" tabindex="3" />
</td>
User is offlinePM
Go to the top of the page
Toggle Multi-post QuotingQuote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 



- Lo-Fi Version Time is now: 8th December 2019 - 10:15 AM