I have a 3 Macros in a workbook that are pulling tabs, pasting the information as values, auto populating the file name, and saving the file to same file path.
All three are identical, except for the tabs that are pulled from the file.
I continue to get a runtime '9' error when it gets to the...