web forms and multiselect

ajw123

New Member
Joined
Sep 17, 2011
Messages
1
I am trying to automate the import of some data from a password protected website onto my excel sheet that performs some calculations on it. I have gotten it up to the point of logging in, and selecting the correct report to export, but now I am having some troubles selecting the appropriate variables in the report.

For example, in this multi-select box, I need to select both Employee Number and Employee name:

g0nKm.png


But with my code:
objFrms("employee_identifier").Value = "NAME"

I can only select either Employee Name or Employee Number, and not both. I have tried several variations of the code, and I can NOT get it to select both. Does anyone have any insight, or has gone through the same?

Thanks!
 

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
Something like:

selectElement.Options(0).Selected = True
selectElement.Options(1).Selected = True

where selectElement is the object which references the HTML select element in the form. Options(0) is the first option in the select element.
 
Last edited:
Upvote 0

Forum statistics

Threads
1,224,613
Messages
6,179,898
Members
452,948
Latest member
Dupuhini

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top