Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 4 of 4

Thread: VBA : Passing Username and Password for website

  1. #1
    Join Date
    12th January 2004
    Posts
    180
    I have the following String created to send a request to a website location. I would like to pass the required Username and Password to provide authentication when I send the request.

    Any suggestions?

    strFaceUrl = "http://.com/W/servlet/EcnRptFacePage.xml?ecn_in=" & TextBox1.Text & ""
    ThisWorkbook.FollowHyperlink strFaceUrl

    Thanks for the help,
    john

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    12th January 2004
    Posts
    180
    I'm throwing this out...NOT literally but just to see if anyone has a suggestion for the code below so that it sends authentication with the request.

    Without username and password a popup window opens and requests username and password. Is there a step or two I'm missing to complete authentication?

    Private Sub CreateBOM_Click()
    Dim strBomChgUrl As String
    Dim username As Variant
    Dim password As Variant

    strBomChgUrl = "http://.com/W/servlet/ EcnRptBomChange.xml?ecn_in=" & TextBox1.Text & "" + username = "user" & password = "pass"
    ThisWorkbook.FollowHyperlink strBomChgUrl

    End Sub

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    7th March 2003
    Location
    Essex, England
    Posts
    11,313
    Hi John,

    How about.

    "http://userass@.com/W/servlet/ EcnRptBomChange.xml?ecn_in=" & TextBox1.Text

    Chers
    Andy

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    12th January 2004
    Posts
    180
    Hi Andy,

    Thanks for the suggestion...it didn't take.

    I think I need to dig a little more to verify I'm passing username and password as it would be requested by the java script.

    cheers,
    John

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. SQL Database On Server Prompts For UserName & Password
    By sandyshaw in forum Excel and/or SQL Help
    Replies: 6
    Last Post: August 6th, 2010, 15:54
  2. Automate Username & Password Log In To Web Page
    By grim sleeper in forum EXCEL HELP
    Replies: 3
    Last Post: November 21st, 2007, 07:35
  3. Enter Username & Password On Web Page
    By amirampeled in forum EXCEL HELP
    Replies: 4
    Last Post: October 25th, 2007, 03:13
  4. Web Query. Log on Username & Password
    By giogugio in forum EXCEL HELP
    Replies: 11
    Last Post: January 24th, 2007, 22:18
  5. Replies: 15
    Last Post: February 1st, 2005, 17:44

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
porno