Question

Vbscript/wsh to automate web authentication and logout with no user input boxes necessary

Asked by: frustratedprog

Desperate to obtain answer to enable users to click vbs icon to automate web authentication to secure website. Want user 2 click on icon,be signed in and then be logged out. Have code to launch website but loginid/password segment has been eluding me 4 several weeks and have to face the piper this Monday. Would like users to be able to automatically logout too but if I could get first segment to work [company id, login id,password] would be estatic.  my code currently [test with my email]  is as follows, but again can't automate getting login and password and then hitting submit key/enter key. Would the tab & send key codes be useful in this type of scenerio?  Pls note this will actually be for a secure  online account website that not only needs login id and password but also company id [which is first parameter b 4 loginid and password so its actually 3 inputs. NO MSG BOXES ALLOWED.  Just and icon to click login and get back out of application [perhaps sleep a few seconds before it logs out. Thanks immensly.... a whole lot of immensly. Pls assist. should I combine with ASP , javascript, to work? if so how? Remember site is already built so I am not incorporating into and html script. Just trying 2 hit the secure website site.

 '[iewithurl.vbs]

' Display a URL
Dim IE
Dim uSERNAME
Dim PASSWORD
Dim crtScreen
Set IE = CreateObject("InternetExplorer.Application")
USERNAME = "I want to put in specific password and login I feed it as an administrator that will always be used no matter who I give vbs icon to....."
PASSWORD = "XXXXXXX"

With IE
        .left=200
        .top=200
        .height=400
        .width=400
        .menubar=0
        .toolbar=1  
        .statusBar=0
        .navigate "http://mail.yahoo.com/?.intl=us"
        .visible=1
End With

'wait a while until IE as finished to load
Do while IE.busy
loop

Set IE = Nothing

WScript.Quit(0)


****************************************************************
I HAVE ALSO ADDED THE FOLLOWING SECTION to the end of the previous BUT IT JUST SITS THERE AFTER THE SITE IS LAUNCHED too.  at least it did not generate an error but it did not work either. just another idea

******************************************************************

Sub Main

  crt.Screen.Synchronous = True

  ' connect to host on port 23 (the default telnet port)
  '
  'crt.Session.Connect "/TELNET login.myhost.com 23" *****this was code I saw using telnet instead of http to hit a site which I tried but did not work **********

  crt.Screen.WaitForString "ogin:"

  'crt.Screen.Send "myusername" & vbCr

  crt.Screen.Send "USERNAME" & vbTab

  crt.Screen.WaitForString "assword:"

  'crt.Screen.Send "mypassword" & vbCr

  crt.Screen.Send "PASSWORD" & vbCr

  crt.Screen.Synchronous = False

End Sub


WScript.Quit(0)

# $language = "VBScript"
# $interface = "1.0"

' Connect to an SSH server using the SSH2 protocol. Specify the
' username and password and hostname on the command line as well as
' some SSH2 protocol specific options.

Sub Main

  'Dim host
  Dim Yahooid
  'host = "ssh.somecompany.com"
  'Dim user
  Dim PASSWORD
  PASSWORD = " do i put real password here to make it work...don't want it to set up cookies, want it 2 work with specific password and login i feed it initially l"
  'user = "myusername"

  ' Prompt for a password instead of embedding it in a script---DON'T WANT TO DO THIS BUT I WILL IF I HAVE TO...
  '
  Dim passwd
  passwd = crt.Dialog.Prompt("Enter password for " & host, "Login", "",
True)

  ' Build a command-line string to pass to the Connect method.
  '
  cmd = "/SSH2 /L " & user & " /PASSWORD " & passwd & " /C 3DES /M MD5
" & host

  crt.Session.Connect cmd

End Sub
psl remember this will not be for a simple email sign in. I just used used email to test. I need it to auto sign on to an online account with 3 input fields.

thanks... frustratedprog

This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.

Subscribe now for full access to Experts Exchange and get

Instant Access to this Solution

  • Plus...
  • 30 Day FREE access, no risk, no obligation
  • Collaborate with the world's top tech experts
  • Unlimited access to our exclusive solution database
  • Never be left without tech help again

Subscribe Now

Asked On
2003-09-20 at 09:17:39ID20744213
Tags

vbscript

Topics

Miscellaneous Programming

,

Windows Batch Scripting

Participating Experts
3
Points
250
Comments
21

Trusted by hundreds of thousands everyday for fast, accurate and reliable tech support.

  • "The time we save is the biggest benefit of Experts Exchange to Warner Bros. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange." Mike Kapnisakis, Warner Bros.
  • "Our team likes having a resource that is more secure than just using Google and most experts using this service really know their stuff. It's nice to look here first versus using Google." Dayna Sellner, Lockheed Martin
  • "Anytime that I've been stumped with a problem, 9 out of 10 times Experts Exchange has either the accepted solution or an open discussion of the potential solution to the problem." Kenny Red, eBay Inc.

See what Experts Exchange can do for you.

Got a question?

We've got the answer.

Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.

Screenshot of Experts Exchange Knowledgebase

Need individual assistance?

Our experts are ready to help.

If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.

Screenshot of Experts Exchange Knowledgebase

Want to learn from the best?

Read articles from industry experts.

Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.

Screenshot of an Article

Working on a long term project?

Store your work and research.

Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.

Screenshot of Experts Exchange Knowledgebase

Access the answers to your technology questions today.

Subscribe Now

30-day free trial. Register in 60 seconds.

What Makes Experts Exchange Unique?

Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.

Trusted by the world's most respected brands.

image of each brand's logo

Faithfully serving IT professionals since 1996.

Experts Exchange Logo

Try it out and discover for yourself.

Subscribe Now

30-day free trial. Register in 60 seconds.

Related Solutions

  1. VBScript in WSH and a little Database
    I am trying to execute a query on an Access database through VBScript (in the WSH not an ASP file). I consistently recieve errors when i try to execute... here is a list of my trial and errors: VBSCRIPT ERRORS: *querystring prints out as : INSERT INTO new VALUES (account,...
  2. Include files in VBScript (WSH)
    I wonder if there is a way to include other .vbs scripts from a .vbs script I don't mean asp style, like this: <script language="VBScript" src="includefile.vbs"></script> it must run directly under WSH
  3. WSH
    Everybody knows Excel and Word. Built in is the ability to run scripts using the WSH. Now, I would like to have the same thing within my VB6 application. I have objects which need to be accessed by the script and the user may write their own scripts accessing these objects. H...
  4. WSH VBscript - How to determine MS Office version ?
    Using WSH VBscript with MS Word and Outlook. Need to know what version of Office in use so the "CreateObject" will not fail. Example that works with older versions of Outlook: Set objOL = CreateObject("Outlook.Application") Syntax required by Of...

Free Tech Articles

  1. WARNING: 5 Reasons why you should NEVER fix a computer for free.
    It is in our nature to love the puzzle. We are obsessed. The lot of us. We love puzzles. We love the challenge. We thrive on finding the answer. We hate disarray. It bothers us deep in our soul. W...
  2. SCCM OSD Basic troubleshooting
    SCCM 2007 OSD is a fantastic way to deploy operating systems, however, like most things SCCM issues can sometimes be difficult to resolve due to the sheer volume of logs to sift through and the dispe...
  3. Migrate Small Business Server 2003 to Exchange 2010 and Windows 2008 R2
    This guide is intended to provide step by step instructions on how to migrate from Small Business Server 2003 to Windows 2008 R2 with Exchange 2010. For this migration to work you will need the fo...
  4. Create a Win7 Gadget
    This article shows you how to create a simple "Gadget" -- a sort of mini-application supported by Windows 7 and Vista. Gadgets can be dropped anywhere on the desktop to provide instant information, ...
  5. Outlook continually prompting for username and password
    There have been a lot of questions recently regarding Outlook prompting for a username and password whilst using Exchange 2007. There are a few reasons why this would happen and I will try to cover t...
  6. Backup Exchange 2010 Information Store using Windows Backup
    There seems to be quite a lot of confusion around the ability to backup Exchange 2010 using the built in Windows Backup feature. This stems from the omission of this feature prior to Exchange 2007 s...

Cloud Class Webinars

  1. Avoiding Bugs in Microsoft Access
    Alison Balter takes and in-depth look at avoiding bugs in Access. In this webinar you will learn about using the immediate window to debug your applications, invoking the debugger, using breakpoints to troubleshoot, stepping through code, setting the next statement to execute, ...
  2. Top 10 Best New Features in Visio 2010
    Scott Helmers gives live demonstrations of the top 10 new features in Visio 2010. This webinar will teach you how to create compelling diagrams by adding shapes to the page with a single click, linking the shapes in a diagram to data in Excel (or SQL Server, or SharePoint), ...
  3. IT Consultant Business Secrets Revealed
    Michael Munger, Experts Exchange tech pro and IT consultant, pulls back the curtain on his very successful businesses and answers question on every IT consultant and business owner should know about. He shares secrets on what he did to solve the 5 most common problems in IT, ...
  4. Disaster Recovery and Business Continuity
    Quest CTO, Mike Billon, gives an overview of the steps involved in building a dunamic disaster recovery plan. Through case studies and an examination of software/hardware tooles for monitoring and testing, you'll gain a better understandin of where you are, where you want ...
  5. Organize Your Visio Diagrams with Containers and Lists
    Scott Helmers uses cross functional flowcharts, wireframe diagrams, data graphic legends and seating charts to teach you: how to ustilize all three new structured diagram components in Visio 2010, the best practices for organizeing shapes in previous version of Visio, how to organize ...
  6. How to Us Objects, Properties, Events and Methods in Microsoft Access
    Alison Dalter gives an in-depbth look at objects, properties, events and methods in Microsoft Access. In this webinar you will learn about using the object browser, referring to objects, working with properties and methods, working with object variables, understanding the ...

Join the Community

Give a Little. Get a Lot.

Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.

Join the Community

Answers

 

by: bruintjePosted on 2003-09-20 at 11:03:31ID: 9399447

for an idea have a look here

http://www.angelfire.com/realm/vb-shared/IEDOM_Tip06.htm

so what you need is the source code find out what the name / passw / submit is and fill them out through the document object in the IE webbrowser control you already use in the script

 

by: frustratedprogPosted on 2003-09-21 at 03:18:30ID: 9401904

Greetings  Bruintje. The url you directed me to [http://www.angelfire.com/realm/vb... etc ] is  VERY VERY  close to what I need. Except I copied it and tested as a vbs and it did not work. I even tried to fix error but it continously fails at the following line:

Private Sub IE_DocumenteComplete (ByVal pDisp As Object, URL As Variant)
when it gets to the "URL as Variant " part it errors with

char: 45:
Error:expected ')'
Code 800a03ee                     vbscript compilation error

Also is the line:
If InStr(1, URL "passport.come/cgi-bin/login" , vbTExtCompare ) going to work since there are no cgi-bins in the sourcecode when viewing hotmails sourcecode?

Overall, to answer your question, I need the source code to AUTOMATICALLY accept  the name /passwd/submit key stroke that I put in as the adminstrator...and then  fill them out through the document object in the IE webbrowser control you already use in the script .

If I ,as the administrator provide the name /password I want to be used then users only have to click vbs icon get in application to see if webserver or email site is up/available and then automatically log users out.
*so user clicks vbs icon
*vbs icon automatically logs user in with login/password from sourcecode in script
*If user automatically gets in the that will mean application is up and abvailable
*then vbs script will log user out.
End of script with no user interaction except clicking vbs icon on desktop.

Hope this clarification helps Bruintje.  Thanks 4 getting back to me so quickly:) I may just be on my way to success.

 

by: bruintjePosted on 2003-09-21 at 03:51:58ID: 9401958

vbscript doesn't do variable declarations so change it to

Private Sub IE_DocumenteComplete (ByVal pDisp, URL)

next the cgi thing, depending on your source [seeing yahoo in your first comment] you need to find out the correct input boxes from there

i think with mail at yahoo the thing to watch is the form post method around this line in the html source
<form method=post action="https://login.yahoo.com/config/login

if you can fill the boxes with name and pwd then finding out the click or post url is the rest of the work

 

by: frustratedprogPosted on 2003-09-21 at 09:06:21ID: 9402810

ok Bruintje. I will give this a try and get back to u today. thanks...

 

by: bhagyeshtPosted on 2003-09-21 at 22:52:52ID: 9403677

just modified your code a vee bit.
Dim IE
Dim uSERNAME
Dim PASSWORD
Dim crtScreen
Set IE = CreateObject("InternetExplorer.Application")
USERNAME = "I want to put in specific password and login I feed it as an administrator that will always be used no matter who I give vbs icon to....."
PASSWORD = "XXXXXXX"

With IE
       .left=200
       .top=200
       .height=400
       .width=400
       .menubar=0
       .toolbar=1  
        .statusBar=0
       .navigate "http://www.smscountry.com"
        .visible=1
End With

'wait a while until IE as finished to load
Do while IE.busy
loop
IE.document.logincheck.login.value=USERNAME
IE.document.logincheck.password.value=PASSWORD
IE.document.logincheck.submit.click
Set IE = Nothing

WScript.Quit(0)
Enjoy.

 

by: frustratedprogPosted on 2003-09-22 at 06:55:40ID: 9405735

Good morning bruintje and bhagyesht.
   Bruintje    I would have gotten back 2 u yesterday evening but I was literally trying to get the code to work with the suggestions u made, but it would not work. I tried & tried until 11Pm. Then came in at 5:30 Am. I get no errors, but an IE window does not even launch either, let alone trying to get the login/password to input automatically. I will keep trying to tweak the code in case I am missing something...

bhagyesht     I tried your code which actually launched an IE window. I  switched to my yahoo email address [ and tried your smscountry url too...smile] but in either case, I get a  windows script host error on line 24 namely:
Error: Object doesn't support this property or method: 'document.logincheck'
code: 800a01b6
source: Microsoft VBScript  runtime error.

line 24 is the line that states ............IE.document.logincheck.login.value=USERNAME

also I will have to use a tab to get to the next field of password after the login is entered , then finally the submit button.
so if I can get it to work ,  should I be utilizing  VbTab  in this code also?  Just wondering.

I feel with either method I am almost there but not quite. Only have a few hours left to come up with the answer so and other suggestions would greatly be appreciated.......Nothing beats a failure [me] but a try........
frustratedprog

 

by: bhagyeshtPosted on 2003-09-22 at 21:00:12ID: 9410449

no the problem is that though ie has returned its not buzy its still not parsed the data.
add these lines after the
ie.buzy loop

Do While UCase(IE.Document.readyState) <> "COMPLETE"
    Sleep (100)
    DoEvents
Loop

It should work.

 

by: frustratedprogPosted on 2003-09-24 at 05:00:01ID: 9419928

Good morning bhagyesht.
Ok I will certainly try this since I was given a bit more time and get back to you early tomorrow morning so I may close this case and give credit.
frustrated prog

 

by: bhagyeshtPosted on 2003-09-24 at 05:08:03ID: 9419971

ok

 

by: frustratedprogPosted on 2003-09-29 at 04:05:26ID: 9450427

Hmm I tried and still an error. I will provide error to you so I can close this case. thank you

 

by: bhagyeshtPosted on 2003-09-29 at 04:07:50ID: 9450435

sure can u post the error?

 

by: frustratedprogPosted on 2003-10-01 at 04:43:52ID: 9465826

Good morning bhagyesht
wow,  still get error message as follows after I added these lines:

ie.busy loop

Do While UCase(IE.Document.readyState) <> "COMPLETE"
   Sleep (100)
   DoEvents
Loop

line:28
char 1
object doesn't support this property or method :'Document.logincheck'
code: 800a01b6
source: Microsoft VBScript runtime error

any other suggestions please????? I am willing to try anything at this point please.

 

by: bhagyeshtPosted on 2003-10-01 at 04:49:40ID: 9465859

u tried with smscountry or some other site? if some other site does the site have the name of the form as logincheck? can u pass the name of the site?

 

by: bhagyeshtPosted on 2003-10-01 at 04:50:33ID: 9465864

logincheck is the name of the form so for another site u need to adjust it to your form name

 

by: bhagyeshtPosted on 2003-10-01 at 05:01:44ID: 9465928

ok his one works fine on my pc just put ur login name and password

Dim IE
Dim uSERNAME
Dim PASSWORD
Dim crtScreen
Set IE = CreateObject("InternetExplorer.Application")
USERNAME = "I want to put in specific password and login I feed it as an administrator that will always be used no matter who I give vbs icon to....."
PASSWORD = "XXXXXXX"

With IE
      .left=200
      .top=200
      .height=400
      .width=400
      .menubar=0
      .toolbar=1  
        .statusBar=0
      .navigate "http://www.smscountry.com"
        .visible=1
End With

'wait a while until IE as finished to load
Do while IE.busy
loop
set WshShell = WScript.CreateObject("WScript.Shell")
Do While UCase(IE.Document.readyState) <> "COMPLETE"
      WScript.Sleep 100
   DoEvents
Loop
set WshShell=nothing
IE.document.logincheck.login.value=USERNAME
IE.document.logincheck.password.value=PASSWORD
IE.document.logincheck.submit.click
Set IE = Nothing

WScript.Quit(0)

 

by: frustratedprogPosted on 2003-10-01 at 13:57:44ID: 9469754

Good afternoon Behagyesht. I had tried my yahoo email site. I will try this new one with both the smscountry site AND also again with my email site and then let you know. Sorry for the long lag. I have been getting long hours at work coming to work at  6:15 am to late in evenings of 8:30, 9  PM. Will get back to you sooner this time. On form I am working on it only states

function setFocus() {
      if (document.forms.length > 0) {
            document.forms[0].elements[0].focus();
and also html 4 code  td class="bkgnd" height="5" colspan="4"><form name="sbLogonForm" method="POST" action=
and
<td class="input" width="50%">&nbsp;<input type="text" name="companyID" maxlength="32" size="12" value="">
   

*

</td>
 <td class="wtspace">&nbsp;</td>
</tr>
<tr bgcolor="#ffffff">
 <td class="wtspace">&nbsp;</td>
 <td class="label" width="50%">User ID:&nbsp;</td>
 <td class="input" width="50%">&nbsp;<input type="text" name="j_username" maxlength="32" size="12" value="">
   

*

</td>
 <td class="wtspace">&nbsp;</td>
</tr>
<tr bgcolor="#ffffff">
 <td class="wtspace">&nbsp;</td>
 <td class="label">Password:&nbsp;</td>
 <td class="input">&nbsp;<input type="password" name="j_password"

Nothing much to go on for forms on this one but I will close this question  out tomorrow since you gave me plenty of ideas.

 

by: frustratedprogPosted on 2003-10-07 at 05:30:23ID: 9505107

Although I could not get the signon to work you both pointed me in the right direction and I sincerely appreciate that. Thank you for lending your excellent ideas and options.!!!!!
BTW this was my first time so I hope I credited correctly and most of all fairly. I wanted to split the points because you BOTH gave time and allotted it to the issue.  Thanks again.

 

by: bhagyeshtPosted on 2003-10-07 at 05:41:33ID: 9505172

I still would like to know if there is a public site u faced a problem?

I was able to log on to yahoo's mail too.
the following is the code

change the username and password values


Dim IE
Dim uSERNAME
Dim PASSWORD
Dim crtScreen
Set IE = CreateObject("InternetExplorer.Application")
USERNAME = "XXXXXX"
PASSWORD = "YYYYY"

With IE
      .left=200
      .top=200
      .height=400
      .width=400
      .menubar=0
      .toolbar=1  
        .statusBar=0
      .navigate "http://mail.yahoo.com"
        .visible=1
End With

'wait a while until IE as finished to load
Do while IE.busy
loop
set WshShell = WScript.CreateObject("WScript.Shell")
Do While UCase(IE.Document.readyState) <> "COMPLETE"
      WScript.Sleep 100
   DoEvents
Loop
set WshShell=nothing
IE.document.login_form.login.value=USERNAME
IE.document.login_form.passwd.value=PASSWORD
IE.document.login_form.submit
Set IE = Nothing

WScript.Quit(0)

 

by: frustratedprogPosted on 2003-10-10 at 04:52:32ID: 9526959

Good morning bhagyesht. I will get back to you regarding why it did not work for site as soon as I can. But for now I just wanted to let u know it was difficult identifying the "form name" and perhaps that is why it did not work.
 I will provide u with more detail later but in my previous post I tried to copy some of the "source" code to show why it was hard to locate. . Of course I still could not produce what the boss wanted so I am still in trouble but at least I tried and with your assistance I was able to get a little further. Hopefully my punishment won't be too severe. Either way I will get back to you.

 

by: bhagyeshtPosted on 2003-10-10 at 05:00:16ID: 9527007

sure! when ever you get free I'll like to know.
BTW which country are you from?
Bhagyesh

 

by: netmgmtPosted on 2010-07-16 at 02:26:33ID: 33220253

Automating Authentication to sharepoint hosted Intranet Site using vbs script?
Scenario:
Company (A) IT Services Split from Company (B), they both now running their own infrastructure. Company (A) need access to Company (B) Intranet that hosted on sharepoint site. Company (B) agreed to provide company (A) with access to the intranet, under condition they use Active Directory Authentication. and they provided company (A) with only one login account to be used by all their staff. because the password is complex, many users type the account credential wrong which result for the account to be locked out for 5 minutes.

I find the script above to be very usefull for our situation but the problem it doesnt work for our situation:
When the user access the website they get authentication pop up windows that generated by Internet explorer and it use different form check method,

have alook at the following picture for clarification:
http://img143.imageshack.us/img143/6498/automatingintranetacces.png

when i run the script below i get error as shown on the image below :
http://img340.imageshack.us/img340/2359/11018341.png

Can you please tell me whats is the login form method for internet explorer generated pop up windows

Dim IE
Dim uSERNAME
Dim PASSWORD
Dim crtScreen
Set IE = CreateObject("InternetExplorer.Application")
USERNAME = "Domain\username"
PASSWORD = "DOMAINPASSWORD"

With IE
      .left=200
      .top=200
      .height=400
      .width=400
      .menubar=0
      .toolbar=1  
        .statusBar=0
      .navigate "http://intranet.blah.blah.au/"
        .visible=1
End With

'wait a while until IE as finished to load
Do while IE.busy
loop
set WshShell = WScript.CreateObject("WScript.Shell")
Do While UCase(IE.Document.readyState) <> "COMPLETE"
      WScript.Sleep 100
   DoEvents
Loop
set WshShell=nothing
IE.document.login_form.login.value=USERNAME
IE.document.login_form.passwd.value=PASSWORD
IE.document.login_form.submit
Set IE = Nothing

WScript.Quit(0)



20120131-EE-VQP-002

3 Ways to Join

30-Day Free Trial

The Experts

98% positive feedback on 31,087 answers since March 2000. angeliii is a Microsoft Most Valuable Professional for his work with MS SQL Server & Develoment.

He has also proven his knowledge of Visual Basic Programming, PHP Scripting and Oracle Databases.

The Experts

97% positive feedback on 10,752 answers since July 2000. lrmoore has more than 18 years experience in the networking industry.

The six-time Mircosoft MVPs specialties include firewalls, virtual private networking, and network management.

Testimonials

"...and excellent source for support... Kind of like having your very own IT dept." Electriciansnet

Testimonials

"I was apprehensive at signing up at first. However... it has already made my life as an IT administrator much easier." JaCrews

Testimonials

"WOW! You guys have great, active, and knowledgeable people on here." moore50

Business Clients

Business Clients

In the Press

"If you’ve got a question... Experts Exchange can supply an answer.”

In the Press

"...an invaluable aid for both IT professionals and those who require tech support."

In the Press

"where IT professionals provide quick answers on just about any topic"

Business Account Plans

Loading Advertisement...