I told the user to name the files as This_Report_07-01-2015. Actually this is how they've been naming it so it wasn't my idea. Now the person is inserting Spaces instead of Underscores. It crashed my macro because it was expecting an underscore. Is there a way to deal with this? No, I'm not going to rename all the files.