Trouble logging to SAP from Excel: Error "Name or password is incorrect"

[Former Member]

Hi,

When I am logging to SAP(APO) from Excel using VBA, I am getting error

"Name or password is incorrect" "repeat logon".

I have made my password in CAPITAL letters.

Also I have the authorization S_RFC.

Still I am not able to logon.

If any changes are required in Profile Parameter, let me know.

Is there any setting that I should do in sm59.

What steps should I do, so that I can login to SAP.

Regards,

Vikas

[Former Member]

Hi Vikas,

is your password in SAP also in capital letters? I think from ecc5 it's important.

Regards, Dieter

[Former Member]

Hi Dieter,

My password in SAP is in Capital letters.

Regards,

Vikas

[Former Member]

Hi Vikas,

i do it in this may:

If sapConnection.logon(0, True) <> True Then

MsgBox "Keine Verbindung zum R/3!"

Exit Sub

End If

It shows the LOGON-Window. Did you do like me?

Regards, Dieter

[Former Member]

Hi Dieter,

I had given the 2nd paramter as False so that the logon screen comes.

I enter the user id, pwd, system in the logon screen.

Even after, I am getting the error.

Don't know whether if it is w.r.t profile parameter.

Regards,

Vikas

[Former Member]

Hi Vikas,

you are right with FALSE.

I don't have any other solution.

Do you tried to logon with your UID and password direkt in SAPLOGON

and is this logon OK?

Regards, Dieter

[Former Member]

Hi Dieter,

I can login to APO system, using the SAP Gui.

But I am not able to login using excel.

Regards,

Vikas

[Former Member]

Hi Vikas,

sorry, but i have no other ideas, perhaps any other member of

this forum can help you.

good luck.

Regards, Dieter

Can you show the VBS-Code, i will test it in my System

Regards, Dieter

Message was edited by:

Dieter Gröhn

[Former Member]

Had a similar issue with an RFC application logon to SAP ECC6 when the password was longer than 8 characters. Can't remember exact solution - but it was in a SAP Note. I believe there was a DLL to replace / update to cater for the longer ECC6 passwords - but logon worked OK if password was all upper case and 8 characters or less.

Maybe this is your issue.

Andrew

[Former Member]

Hi Andrerw,

Thanks.

My question has been resolved.

The pwd reqrd to be less than 8 chars.

Regards,

Vikas