Keep original file open after saving modified copy

I am not a VBA expert. I learned by trial and error and from "Google" university and this fine Forum.

I have a file that is used every month. It is linked to 6 disparate data source files which change every month. The file harvests selected data from them, modifies, and reformats it into our preferred client report.

After running the harvesting for one client against the data files, I currently have a macro that performs some modification (Copy and Paste as Values, Break Links, Select tabs to be included in modified file, etc.) against the file.

Currently that macro ends by saving the modified file which checks for separate folder presence, creates if not present, and checks for Year sub folder, and creates if not present, and saves modified file.

The way the macro is programmed, I currently close the modified file manually, and then reopen the original file, select the next client from a pull-down list, and repeat the modify macro, then manual close, and open process.

I used to have some code that created the modified the file, and saved it, without changing or closing the original file. I don't seem to find it and I can't find what I need online.

What would the best way to change this the modification macro to save the file using the same check folder and naming convention in the macro, but without having to close the modified file and then reopen the original file?

Here is the check folder and naming convention part of the modification macro... sorry I did NOT find the Vbcode button mentioned in the help area....

Please Login or Register  to view this content.

Thank for your input and suggestions.
Bob

At the end of the Check_Folder_Save_File_In_Year_Folder procedure add:

Please Login or Register  to view this content.

Also add the following procedure:

Please Login or Register  to view this content.

Artik

and reformats it into our preferred client report.

select the next client from a pull-down list, and repeat the modify macro,

I used to have some code that created the modified the file, and saved it, without changing or closing the original file.

This tells me that you need to change your code...I suggest a loop through those selections and then making use of similar code to what you lost to create your reports...keeping your main workbook open and saving created copies to the folders...
Not sure of your setup as no sample file...Perhaps you can upload a sample file explaining your required steps and I'm am very certain someone will create the correct solution...

@ shepardrf

I've added the code tags for you - click on Edit Post to see how I did that.

Posting code between [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Guideline #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here.