I'm running a script that merges all files that I have located within a certain folder. The script works fine, but the output file is simply coming out as "Sheet##" every time I run the macro. I'm trying to have the output sheet saved as a file named "Merge_MM.DD.YY", or something similar, in a specific folder. I've found some code online that created a saved file, but I haven't been able to successfully integrate it into the code I have pasted below. Does anyone know of save-as functions I can write into this?
Bookmarks