mudraker,
Macro works great! First time would not run, found a typo, now works great. Typo was in For Each statement, I changed Workbook to Workbooks. Here is the finished product...
And now let me move to the next step of the learning curve. I understand most of the code except for " sFile$ = Dir ", and I do understand that sFile is a variable and you are populating it with the file names in the directory. What I don't understand is how the code only goes through the directory once, how does it know to stop at the last file and not to loop?
Also, why the $ signs after the variable names?
I appreciate you taking the time. Thanks
ww
Bookmarks