By "automatically generated", I assume you mean that there is some VBA code
that creates a spreadsheet, writes data into it, then does a SaveAs to
folder_1\file_1

Why not just follow that with another SaveAs command to folder_2\file_2
--
TedMi