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
|