Help - Search - Members - Calendar
Full Version: Help with HTML/EXCEL integration
HTMLHelp Forums > Web Authoring > Markup (HTML, XHTML, XML)
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"

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.;tcCmpId=ALS

Any help would be appreciated.

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


<td nowrap="nowrap" class="Bold">
    <input name="txtPassword" type="password" maxlength="20" id="txtPassword" tabindex="3" />
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2019 Invision Power Services, Inc.