Works perfectly!! Thank you soooo much. You've saved me hours and hours of work!!


Now perhaps you could help me understand some of the logic, so I can reason through other projects.


Do While inputfile <> vbNullString
How is this, as a counting devise,telling the loop that it is finished? Why doesn't it end in with an infinite loop if there are always files in the directory?

Also, the file are linked to other files. it seems they are not updating from their links so i'm saving #value signs into the cells. any suggestions to combat this?

Thanks again for your help. This is a huge time saver!