Hi DeanL, Paul gave a great answer, but I am not sure you are going to be happy with it... Can you please send one of those workbooks aka spreadsheets and specify clearly what "piece of code in the back" should have which modification... I will give you in return a .vbs that iterates through those files, especially if you give a clear specification such as "all .xls in folder c:\blablabla" or "xyz*.xls in disk d: etc...
Greetings, Paul Willekens -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe To unsubscribe, reply using "remove me" as the subject.
