I have a good feeling this is not possible, but is there a way to pass
information from an Excel user form, i.e.-username and password, into login
fields on a web site?
I currently have a command button which opens the site in IE, which is fine
for me (I don't mind typing in the info once I get there---and I know the
password by heart) but some of the users have a hard time remembering not
only the username/password, but where they have it written down, as well.
It doesnt seem possible to me, considering I dont know of any way to
specify where the information is supposed to go once the web page is open,
but I thought Id post this just in case someone out there knows how to work
some magic.

--
Matty

On Apr 14, 12:28*pm, MaddyDread
wrote:
I have a good feeling this is not possible, but is there a way to pass
information from an Excel user form, i.e.-username and password, into login
fields on a web site? *
I currently have a command button which opens the site in IE, which is fine
for me (I don't mind typing in the info once I get there---and I know the
password by heart) but some of the users have a hard time remembering not
only the username/password, but where they have it written down, as well.
It doesn’t seem possible to me, considering I don’t know of any way to
specify where the information is supposed to go once the web page is open,
but I thought I’d post this just in case someone out there knows how to work
some magic.

--
Matty

Matty...Yes, this can be done. Here is a snippet of code that you
would put in your module to accomplish what you want

Set ie = CreateObject("InternetExplorer.Application")

With ie
.Visible = True
.Navigate "http://www.yourwebsite.com/"
.Top = 50
.Left = 530
.Height = 400
.Width = 400

' Loop until the page is fully loaded
Do Until Not ie.Busy And ie.ReadyState = 4
DoEvents
Loop

' Make the desired selections on the Login web page and click the
submit button
Set ipf = ie.document.all.Item("username")
ipf.Value = "your username"

Set ipf = ie.document.all.Item("password")
ipf.Value = "your pw"
ie.document.all.Item("frmlogin").submit

' Loop until the page is fully loaded
Do Until Not ie.Busy And ie.ReadyState = 4
DoEvents
Loop

End With


You will need to look at the source code behind the web page and find
out what terms they use for "username", password" and the login form.
If you post the url, I could be more specific...Ron

Hi Ron,
Thanks for the response! I haven't gotten a chance to try that out yet, but
the url is https://gateway.usps.com/bcg/login.htm

Thanks!!
--
Matty


"ron" wrote:

On Apr 14, 12:28 pm, MaddyDread
wrote:
I have a good feeling this is not possible, but is there a way to pass
information from an Excel user form, i.e.-username and password, into login
fields on a web site?
I currently have a command button which opens the site in IE, which is fine
for me (I don't mind typing in the info once I get there---and I know the
password by heart) but some of the users have a hard time remembering not
only the username/password, but where they have it written down, as well.
It doesnt seem possible to me, considering I dont know of any way to
specify where the information is supposed to go once the web page is open,
but I thought Id post this just in case someone out there knows how to work
some magic.

--
Matty

Matty...Yes, this can be done. Here is a snippet of code that you
would put in your module to accomplish what you want

Set ie = CreateObject("InternetExplorer.Application")

With ie
.Visible = True
.Navigate "http://www.yourwebsite.com/"
.Top = 50
.Left = 530
.Height = 400
.Width = 400

' Loop until the page is fully loaded
Do Until Not ie.Busy And ie.ReadyState = 4
DoEvents
Loop

' Make the desired selections on the Login web page and click the
submit button
Set ipf = ie.document.all.Item("username")
ipf.Value = "your username"

Set ipf = ie.document.all.Item("password")
ipf.Value = "your pw"
ie.document.all.Item("frmlogin").submit

' Loop until the page is fully loaded
Do Until Not ie.Busy And ie.ReadyState = 4
DoEvents
Loop

End With


You will need to look at the source code behind the web page and find
out what terms they use for "username", password" and the login form.
If you post the url, I could be more specific...Ron
.

On Apr 16, 10:22*am, MaddyDread
wrote:
Hi Ron,
Thanks for the response! *I haven't gotten a chance to try that out yet, but
the url ishttps://gateway.usps.com/bcg/login.htm

Thanks!!
--
Matty



"ron" wrote:
On Apr 14, 12:28 pm, MaddyDread
wrote:
I have a good feeling this is not possible, but is there a way to pass
information from an Excel user form, i.e.-username and password, into login
fields on a web site? *
I currently have a command button which opens the site in IE, which is fine
for me (I don't mind typing in the info once I get there---and I know the
password by heart) but some of the users have a hard time remembering not
only the username/password, but where they have it written down, as well.
It doesn’t seem possible to me, considering I don’t know of any way to
specify where the information is supposed to go once the web page is open,
but I thought I’d post this just in case someone out there knows how to work
some magic.

--
Matty

Matty...Yes, this can be done. *Here is a snippet of code that you
would put in your module to accomplish what you want

* * Set ie = CreateObject("InternetExplorer.Application")

* * With ie
* * * * .Visible = True
* * * * .Navigate "http://www.yourwebsite.com/"
* * * * .Top = 50
* * * * .Left = 530
* * * * .Height = 400
* * * * .Width = 400

' Loop until the page is fully loaded
* * * * Do Until Not ie.Busy And ie.ReadyState = 4
* * * * * * DoEvents
* * * * Loop

' Make the desired selections on the Login web page and click the
submit button
* * * * Set ipf = ie.document.all.Item("username")
* * * * ipf.Value = "your username"

* * * * Set ipf = ie.document.all.Item("password")
* * * * * * ipf.Value = "your pw"
* * * * ie.document.all.Item("frmlogin").submit

' Loop until the page is fully loaded
* * * * Do Until Not ie.Busy And ie.ReadyState = 4
* * * * * * DoEvents
* * * * Loop

* * End With

You will need to look at the source code behind the web page and find
out what terms they use for "username", password" and the login form.
If you post the url, I could be more specific...Ron
.- Hide quoted text -

- Show quoted text -

Matty...This should work for that url...ron

Set ie = CreateObject("InternetExplorer.Application")

With ie
.Visible = True
.Navigate "https://gateway.usps.com/bcg/login.htm"
.Top = 50
.Left = 530
.Height = 400
.Width = 400

' Loop until the page is fully loaded
Do Until Not ie.Busy And ie.ReadyState = 4
DoEvents
Loop

' Make the desired selections on the Login web page and click the
' submit Button
Set ipf = ie.document.all.Item("login_name")
ipf.Value = "your username"

Set ipf = ie.document.all.Item("user_password")
ipf.Value = "your pw"

ie.document.all.Item("signIn").Click

' Loop until the page is fully loaded
Do Until Not ie.Busy And ie.ReadyState = 4
DoEvents
Loop

End With

Thank you SO MUCH Ron! It works perfectly! You've been a great help!
--
Matty


"ron" wrote:

On Apr 16, 10:22 am, MaddyDread
wrote:
Hi Ron,
Thanks for the response! I haven't gotten a chance to try that out yet, but
the url ishttps://gateway.usps.com/bcg/login.htm

Thanks!!
--
Matty



"ron" wrote:
On Apr 14, 12:28 pm, MaddyDread
wrote:
I have a good feeling this is not possible, but is there a way to pass
information from an Excel user form, i.e.-username and password, into login
fields on a web site?
I currently have a command button which opens the site in IE, which is fine
for me (I don't mind typing in the info once I get there---and I know the
password by heart) but some of the users have a hard time remembering not
only the username/password, but where they have it written down, as well.
It doesnt seem possible to me, considering I dont know of any way to
specify where the information is supposed to go once the web page is open,
but I thought Id post this just in case someone out there knows how to work
some magic.

--
Matty

Matty...Yes, this can be done. Here is a snippet of code that you
would put in your module to accomplish what you want

Set ie = CreateObject("InternetExplorer.Application")

With ie
.Visible = True
.Navigate "http://www.yourwebsite.com/"
.Top = 50
.Left = 530
.Height = 400
.Width = 400

' Loop until the page is fully loaded
Do Until Not ie.Busy And ie.ReadyState = 4
DoEvents
Loop

' Make the desired selections on the Login web page and click the
submit button
Set ipf = ie.document.all.Item("username")
ipf.Value = "your username"

Set ipf = ie.document.all.Item("password")
ipf.Value = "your pw"
ie.document.all.Item("frmlogin").submit

' Loop until the page is fully loaded
Do Until Not ie.Busy And ie.ReadyState = 4
DoEvents
Loop

End With

You will need to look at the source code behind the web page and find
out what terms they use for "username", password" and the login form.
If you post the url, I could be more specific...Ron
.- Hide quoted text -

- Show quoted text -

Matty...This should work for that url...ron

Set ie = CreateObject("InternetExplorer.Application")

With ie
.Visible = True
.Navigate "https://gateway.usps.com/bcg/login.htm"
.Top = 50
.Left = 530
.Height = 400
.Width = 400

' Loop until the page is fully loaded
Do Until Not ie.Busy And ie.ReadyState = 4
DoEvents
Loop

' Make the desired selections on the Login web page and click the
' submit Button
Set ipf = ie.document.all.Item("login_name")
ipf.Value = "your username"

Set ipf = ie.document.all.Item("user_password")
ipf.Value = "your pw"

ie.document.all.Item("signIn").Click

' Loop until the page is fully loaded
Do Until Not ie.Busy And ie.ReadyState = 4
DoEvents
Loop

End With
.