Copy workbook to another location without opening

[leeloo0505]

Hello,
I am trying to copy a workbook without opening it and save it to a different location/file name (2nd workbook) from a third workbook.
Anybody got any ideas?
Thanks,
leeloo

 

[VoG]

Yes, it should do.

 

[bamaisgreat]

ok that part works great. A issue im having now is that the FileCopy file Master Archive(GROUP)TEST.xls is password protected so obviesly the Destination File (Public)Archive.xls is also. Is there something hat could be added where the Destination file is not password protected ? Thanks for your Help

On Error Resume Next
Kill "H:\All\Material Prep Archive\(Public)Archive.xls"
On Error GoTo 0
On Error Resume Next
FileCopy Source:="H:\Burney Table\HYPERLINK TEST\HYPO ARCHIVE\Master Archive(GROUP)TEST.xls", Destination:="H:\All\Material Prep Archive\(Public)Archive.xls"

 

[VoG]

Sorry, I don't know how to do that (I don't think it is possible using FileCopy).

 

[bamaisgreat]

ok, how about a open event in the destination file that will password.unprotect when the workbook is opened ?

 

[VoG]

Try like this

Private Sub Workbook_Open()
Me.Unprotect Password:="xyz"
End Sub

 

[bamaisgreat]

thanks

 

[bamaisgreat]

I have alot of hyperlinks in the FileCopySource "Master Archive(Group)Test.xls" I noticed that they do not work in the Destination "(Public)Archive.xls".
Do you have a idea on what I can do to fix this. Thanks

 

[VoG]

I assume that they no longer point to the correct destination. I do not know how to fix that, sorry.