Merging Workbooks and Saving As in a Specific Location

[jablo1312]

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?

Please Login or Register  to view this content.

[jablo1312]

I was able to figure this problem out. At the end of the script above I posted the following code:

Please Login or Register  to view this content.

Where the Application.Display.Alerts removes and then re-enables teh prompts for "saving over" a file, and the middle code saves the created file as "myfile" everytime, overwriting the previous version.