Hi All,

I have gone through all of the posts on this board and have been unable to determine what my issue is.  I am using the below code to test the login but I keep getting invalid user name, password or token.  The user is set up to not have a token assigned through api and is working fine for all other apps we have running. 

Note I have removed the user id and password and just attached the code:

My question is two - fold:

1.  Do I need to have the excel connector installed to use the office toolkit API?

2.  Is there anything you can see that is wrong with the code below?

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

Dim g_sfApi As SForceOfficeToolkitLib3.SForceSession3
Public LoginTest As Boolean
Public myusername As String
Public mypassword As String
Public myserverurl As String
Public mymessage As String

Sub MyMain()
    LoginTest = True
    If LoginTest = True Then
        myusername = "
        mypassword = ""        'this might be different from below
        'mypassword = "password + token"        'this might be different from below
        myserverurl = "https://test.salesforce.com/services/Soap/c/17.0"
    Else
        myusername = ""
        mypassword = ""        'this might be different from above
        myserverurl = "https://www.salesforce.com/services/Soap/c/17.0"
    End If
     
If SampleLogin(myusername, mypassword) = True Then
    mymessage = "Logged into: " & g_sfApi.ServerUrl
    MsgBox mymessage
    'CreateAccount
Else
    mymessage = "Login failed, " & g_sfApi.ServerUrl & g_sfApi.ErrorField & g_sfApi.ErrorMessage
    MsgBox mymessage
    MsgBox (g_sfApi.ErrorField & g_sfApi.ErrorMessage)
    'Unload Me
End If

End Sub

Public Function SampleLogin(Username, Password) As Boolean
    Set g_sfApi = New SForceOfficeToolkitLib3.SForceSession3
    Debug.Print "Default URL: ", g_sfApi.ServerUrl
   
    If LoginTest = True Then
        g_sfApi.SetServerUrl (myserverurl)
        Debug.Print "New URL: ", g_sfApi.ServerUrl
    End If

    SampleLogin = g_sfApi.Login(Username, Password)
End Function

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

Thank you,