I'm trying to pass a username and password to a secured website using ms access.
I have tried passing the values in the URL (stURL = "Http://
" & stSUser & ":" & stSPass & "@" & stURL_Root) and tried to pass the values using SendKeys while Internet Explorer has the focus.
In the first case (passing values in URL) IE returns the "Page cannot be displayed" error, while username and password are correct.
In the second case the logon dialog opens but the username is not pasted into the Dialog box :
On Error Resume Next
Set Ie = CreateObject("InternetExpl
.Visible = True
Sendkey stPaste 'string for userid has been copied to the clipboard
Can anybody help me with this issue?
Thanks and regards, Johan