Hi. I have a site in which I have to log into and use quite frequently.
Instead of having to fill in each field, I would like to automate this
with a macro if possible. The information for each subsequent page will
be in each row on an excel page.
Example:

Macro will look for first blank to fill in and use first blank (A1) to
fill in.
Macro will look for second blank to fill in and use first blank (A2) to
fill in.

It can either look for empty blanks or titled. I just want to automate
it.

Take a look at the first page of the site if it will help.

https://www.access.fda.gov/oaa/logout


thanx!

If you want to fill in your ID and password, get ROBOFORM. Google for it

--
Don Guillett
SalesAid Software

"J.W. Aldridge" wrote in message
ups.com...
Hi. I have a site in which I have to log into and use quite frequently.
Instead of having to fill in each field, I would like to automate this
with a macro if possible. The information for each subsequent page will
be in each row on an excel page.
Example:

Macro will look for first blank to fill in and use first blank (A1) to
fill in.
Macro will look for second blank to fill in and use first blank (A2) to
fill in.

It can either look for empty blanks or titled. I just want to automate
it.

Take a look at the first page of the site if it will help.

https://www.access.fda.gov/oaa/logout


thanx!

Actually,
I am looking to do a little more than just log in. i need a macro that
would pull the info from an excel spreadsheet.
Any way to do this?
the website above is just the log-in for the site (an example of the
site set up).

thanx

I find that sometimes after you log in you may then use your macro to get
the data.

--
Don Guillett
SalesAid Software

"J.W. Aldridge" wrote in message
oups.com...


Actually,
I am looking to do a little more than just log in. i need a macro that
would pull the info from an excel spreadsheet.
Any way to do this?
the website above is just the log-in for the site (an example of the
site set up).

thanx