Iterating over column and pasting that information into text box on web

[dookie418]

I work for an online college. I will get a list of 80 students to call and I have to copy and paste each student ID from excel into Search Box, then click enter, then click their Active enrollment status.

I've got the workings of the code off another website and tweaked it, but I don't know why there is a run time error every other time I run this macro. It literally runs 50% of the time with no problem but it only opens up A1 (and it doesn't click the Active enrollment status--- don't know how to do that)

I don't know how to have the macro iterate from cell A1 into Search box, hit enter, click Active file, then go to cell A2 and do the same thing until the end of the column, so if I had 80 Student ID's listed in column A, I can run macros and have 80 new Internet Explorer windows with each student's file. What can I do?

[dflak]

I don't know if you can glean anything from this. It's old code and I am sure I have forgotten a lot about it. But there is a section where I set a dropdown box to a specific value (as read from the spreadsheet). I then move on to the next box and loop through the contents of the box - there is a third box whose values are dependent on the selection of the second box. I loop though its contents as well.

The rest of the code you can ignore: I wait for a report to render and then used sendkeys (yuck) to print or download the PDF display.