Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
|
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old November 24th, 2006, 02:08 AM
Registered User
 
Join Date: Nov 2006
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default using excel VB to input username and password

Can anyone help? I just to use the following VB to send a click stroke, anyone can help to identify what I have to do as I cannot get it work because I cannot find the right click name or ID?


  ie.document.all("SEC_username").Value = "XX"
   ie.document.all("SEC_password").Value = "XXXX"
Set ipf = ie.document.all.Item("submit")<---this maybe incorrect.
ipf.Click





<!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML 3.0//EN">
<HTML><HEAD>
<TITLE>XXXXXXXXXXXXXXXXXXXXXXXXXXXX -XXXX</TITLE></HEAD>
<BODY BGCOLOR=#FDBD49>
<FORM METHOD=POST ACTION="http://XXX.XXX.XXX/cgi-bin/ias.cgi">
<INPUT TYPE=HIDDEN NAME=scr VALUE="login.cgi">
<CENTER>
<P><BR><P>
<B>Before you can access this function, you will need to login</B>
<P>
<B>Operator ID:</B>
<INPUT TYPE="TEXT" NAME="SEC_username" Size=10 VALUE="">
<P>
<B>Password:</B>
<INPUT TYPE="PASSWORD" NAME="SEC_password" Size=10 VALUE="">

<P><BR><P>
<INPUT TYPE="HIDDEN" NAME="scriptname" VALUE="/cgi-bin/ias.cgi">
<INPUT TYPE="HIDDEN" NAME="parameters" VALUE="scr=menu_main%2ecgi">
<INPUT TYPE="HIDDEN" NAME="SEC_usertype" VALUE="operator">

<INPUT TYPE="SUBMIT" VALUE="LOGIN">
<INPUT TYPE="RESET" VALUE="Clear">
</CENTER>

</FORM>

</BODY>
</HTML>







Similar Threads
Thread Thread Starter Forum Replies Last Post
Regarding Username and password kuku_ashu Javascript How-To 0 January 4th, 2008 11:28 AM
creating username and password abhishekdubey_997 ASP.NET 2.0 Basics 3 December 20th, 2006 06:05 PM
username and password abhi_loveu2002 ASP.NET 2.0 Basics 1 December 14th, 2006 05:25 AM
Username and password Hennie Access 1 July 28th, 2006 12:43 AM
Username & Password Hennie Access VBA 2 July 25th, 2006 12:33 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.