Thread: SaveAs - VBA
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
[email protected] dladilaco@gmail.com is offline
external usenet poster
 
Posts: 4
Default 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