copy file automatically when open

[ctz]

hi all,I just want to know..its possible to copy file in a folder A and paste it in folder B? it run automatically
the situation is like this..when I open folder A , and I open the file which in there in a meantime it copy the file and paste it in new path/folder without notice by user..can i? possible?

 

[Richard Schollar]

Yes but it does require the user to Enable Macros when they open the first file (if they disable macros then the file won't get copied). Place the following in the ThisWorkbook module of the file in question:

Private Sub Workbook_Open()
ThisWorkbook.SaveCopyAs "C:\test\" & ThisWorkbook.Name  'amend path as appropriate
End Sub

To access the ThisWorkbook module, with the file open in Excel right-click on the little Excel file icon to the left of the File menu. Select View Code.

 

[ctz]

oh..it works!
thanks!