SAPLogon problem in Excel VBA: Password length restriction ?

Hi All,

In my application i am using a silent logon to the R/3 server.

First time the user enters the credentials:

Set Functions = CreateObject("SAP.Functions")

Set conn = Functions.Connection

.

.

IF conn.logon(0, 0) = True Then 'Saves the username n password temporarily

userlogin = conn.User

userPass = conn.Password

End IF

during the flow of application in some parts the conn.logoff() is called.

After that when there's a need for login the following code's used:

IF conn.logon(1, 1) = True Then 'silent login with the previous user & passowrd

Open_connection = True 'Login success

End If

This works perfectly when the password is less than 8 characters. but silent login fails when the password is more than 8 characters. Could somebody tell me if there's any restriction on the pswd length ? Is there any way to resolve the issue

The variable userpass is long enough to hold any length. I believe issue is with conn.Password - the password property of the connection object.

Thanks in advance