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