Thread: SaveAs - VBA
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Jay Jay is offline
external usenet poster
 
Posts: 671
Default 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