pliskers
07-02-2009, 07:49 AM
I have a list of items in an Excel file (File1.xls), each of which appears in a dropdown box in a separate file (File2.xls). I need a looping code that will:
1) Go through the list in File1.xls and for each item
2) Change the dropdown list (in File2.xls) to the sequential item, and
3) Save File2.xls with the dropdown item appended to the file name.
I'm just getting into loops and haven't coded much with dropdown box objects - would appreciate anyone's help with this.
Thank you!
1) Go through the list in File1.xls and for each item
2) Change the dropdown list (in File2.xls) to the sequential item, and
3) Save File2.xls with the dropdown item appended to the file name.
I'm just getting into loops and haven't coded much with dropdown box objects - would appreciate anyone's help with this.
Thank you!