Recent content by F0ur2o

Just in case. The base folder would always be the same. ie c:\testresults\*.xls The naming would be very similar. Here is the thread where i found the first code I tried -- and failed. http://www.ozgrid.com/forum/showthread.php?t=71552 And this loop code seemed more relevant as it did not...

Oops -- wrong thread -- sorry.

Thanks for your quick replies everyone. The base folder would always be the same. ie c:\testresults\*.xls The naming would be very similar. Here is the thread where i found the first code I tried -- and failed. http://www.ozgrid.com/forum/showthread.php?t=71552 And this loop code seemed...

Good afternoon all. I am trying to run the 'loop through a folder' code on multiple workbooks I receive after seminars I hold. The workbooks I receive are full of drop downs that have associated values of 1-3. (About 100 in total) This particular workbook has the drop downs on one worksheet...