Help with Sendkey

[Mr Retirement]

Hello,

I'm trying to automatically enter my username and password that is prompted from a userform. I'm attempting to use the code below. It works fine without the userform present...but when the userform is the active screen, the macro stops working and is waiting for my input. Is there any code that I can use to type into a userform? I unfortunately do not have access to the actual userform code - I need moreorless a keystroke macro to run when prompted - is this possible?

Sub Login()

SendKeys "Username"
SendKeys "{Tab}"
SendKeys "Password"
SendKeys "{Tab}"
SendKeys "{Tab}"
SendKeys "{Enter}"


End Sub

Thanks,
Mr R.

 

[Logit]

.
If you do not have access to the UserForm code .... how will you implement any code within the project ?

It sounds like you are dealing with a workbook that is password protected ? Do you have the password ?

 

[Mr Retirement]

I have access to everything except the userform that is prompting the username/password login. This is because (i think) it is built within an addin that - yes is password protected.

My thought was to be able to use Sendkey to automatically type login information within the prompt - but that hasn't worked.

Mr R.