Print All Options On A Drop Down List after Refreshing Excel Add In - With VBA

Hi all

I have a report that my team has to log into an Excel Add In, change selection in drop down list, Refresh Excel Add In and print off (or save to pdf), then repeat until all selections have been refreshed and printed.

It should be noted that refreshing the data can take some time for each selection therefore the code must be able to be 'patient' enough for the process to properly refresh and print (or save).

I have limited VBA experience and have tried to pull together different code for different purposes.

Please Login or Register  to view this content.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #2 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

I expect all selections (215 in total) in the drop down box to have been refreshed and printed (or saved in pdf) individually.

Many thanks