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:
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!
For example, in this multi-select box, I need to select both Employee Number and Employee name:
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!