Im a new user to Excel, and new to macros so bear with me.

I am working on a project to transfer all the data from a spreadsheet and
enter it into an online form. Each row in the spreadsheet has the information
to complete one form. I am trying to write a macro to do this for me. I've
been using a 3rd party mouse recording macro to select and copy elements from
the spreadsheet into the form. However some information stored in the
spreadsheet can only be entered by a pulldown menu in the online form ie.
State/Country.. Is there anyway to create a macro to select the correct item
from the dropdown that corresponds with the one in the spreadsheet.

Sorry if this question seems idiotic but I'm lost.

The bit I don't understand is why? When you select from a dropdown, you get
a value, but you already have it, so why do you need to simulate the
dropdown action?

--
HTH

Bob Phillips

"Philip White via OfficeKB.com" wrote in message
...
Im a new user to Excel, and new to macros so bear with me.

I am working on a project to transfer all the data from a spreadsheet and
enter it into an online form. Each row in the spreadsheet has the
information
to complete one form. I am trying to write a macro to do this for me. I've
been using a 3rd party mouse recording macro to select and copy elements
from
the spreadsheet into the form. However some information stored in the
spreadsheet can only be entered by a pulldown menu in the online form ie.
State/Country.. Is there anyway to create a macro to select the correct
item
from the dropdown that corresponds with the one in the spreadsheet.

Sorry if this question seems idiotic but I'm lost.

the dropdown is on the web form, the information is stored in excel. i need
to get the data from excel and have it correctly select the correct value in
the dropdown on the webform.

"Philip White via OfficeKB.com" wrote in message
...
the dropdown is on the web form, the information is stored in excel. i
need
to get the data from excel and have it correctly select the correct value
in
the dropdown on the webform.

Examing the website's html source code should review the form variables you
want to fill in.

However unless you can manipulate the site within Excel, you may need to add
a wsh/vbscript to a locally saved version to read the excel values, assign
them to the corresponding variables then finish processing the form per the
site's original code; in which case
usenet(microsoft.public.scripting.vbscript, microsoft.public.scripting.wsh)
may be able to assist with the neccessary code.

If you're using IE then you can automate it from Excel, but you'll need to
be familiar with web scripting and the HTML document object model.
Once you've figured that out you're on your way....


Tim
--
Tim Williams
Palo Alto, CA


"Philip White via OfficeKB.com" wrote in message
...
Im a new user to Excel, and new to macros so bear with me.

I am working on a project to transfer all the data from a spreadsheet and
enter it into an online form. Each row in the spreadsheet has the
information
to complete one form. I am trying to write a macro to do this for me. I've
been using a 3rd party mouse recording macro to select and copy elements
from
the spreadsheet into the form. However some information stored in the
spreadsheet can only be entered by a pulldown menu in the online form ie.
State/Country.. Is there anyway to create a macro to select the correct
item
from the dropdown that corresponds with the one in the spreadsheet.

Sorry if this question seems idiotic but I'm lost.