INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

sendkeys btw. excel to extra 6.5 object_in a password field

sendkeys btw. excel to extra 6.5 object_in a password field

(OP)
Hello Gentleman, could use some help...

When I acquired a password (string) from an inputbox in excel vba, suddenly faced an unusual situation: for a password field in extra 6.5!, sendkeys and/or putstring turns the text into case Insensitive.

DO you faced anything like it?

thank you and happy coding!

RE: sendkeys btw. excel to extra 6.5 object_in a password field

Hi,

So if you were to manually enter a case sensitive password in the terminal emulator, it will log you in, but your program fails to transfer such a password to achieve a successful login?

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: sendkeys btw. excel to extra 6.5 object_in a password field

(OP)
Yep Skip...got it!

RE: sendkeys btw. excel to extra 6.5 object_in a password field

So what do you mean, "got it," for the benefit of others.

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: sendkeys btw. excel to extra 6.5 object_in a password field

(OP)
Here a better explanation:

CODE --> VBA

Dim pass as string:pass = InputBox("Mainframe Pass")
.PutString (pass), 12, 60
.SendKeys ("<Enter>")
.WaitHostQuiet (0)

Keep in mind that the registered password would be "PassWord!02".

The event inputbox occurs into the excel vba code and the user insert: "paSSWord!02"

Then the vba code transports the wrong password correctly to the OIA (using debug.print you can realize it and also inserting it into other fields that are not a password) and the terminal accepts it as the correct password.

RE: sendkeys btw. excel to extra 6.5 object_in a password field

You are aware that in some cases, for instance an IMS system, it's ALL upper case, regardless of what case you enter.

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: sendkeys btw. excel to extra 6.5 object_in a password field

(OP)
YLearnd something new with that...thanks again SkipVought!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close