VBA newbie and first post, so apologies ahead of time. I have 4 weekly .xls files emailed to me (which i save to C:\Documents and Settings\adam.r.mcreynolds\My Documents\Roger\COPS\new weekly files\). These files are deleted every week and 4 new files are added when received (4 files for 4...