SaveAs - VBA
 

Thanks in advance.

An Excel file (Flie_1) is automatically generated every two hours to a
specific folder(Folder_1).

Goal.
I want File_1 to get saved as File_2 to an another folder (Folder_2) as soon
as it is created.

SaveAs - VBA
 

On Apr 10, 7:04*am, Jae <Jay @discussions.microsoft.com wrote:
Thanks in advance.

An Excel file (Flie_1) is automatically generated every two hours to a
specific folder(Folder_1).

Goal.
I want File_1 to get saved as File_2 to an another folder (Folder_2) as soon
as it is created.

Try in Tools/Options Save to define anonther recovery location. Could
help

SaveAs - VBA
 

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

SaveAs - VBA
 

Thank you for your reply.
By "automatically generated", SQL language produced it every two hours automatically. Therefore, I have no control over on that side.

Thanks

Jae

"tedmi" wrote:

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

SaveAs - VBA
 

Thak you for your time.

Since File_1 is overwritten every two hours, I am afraid your answer might
not work.

Thanks

Jae

" wrote:

On Apr 10, 7:04 am, Jae <Jay @discussions.microsoft.com wrote:
Thanks in advance.

An Excel file (Flie_1) is automatically generated every two hours to a
specific folder(Folder_1).

Goal.
I want File_1 to get saved as File_2 to an another folder (Folder_2) as soon
as it is created.

Try in Tools/Options Save to define anonther recovery location. Could
help