I need help in creating a VBA to save file as to a directory. I have the old file names including the directory in Worksheet1. I have the new file names including the new directory in Worksheet2. There are over 200 that needs to be saved as with the new name and directory. Please help.