Copy in code

[mirna]

Hi

I want to copy a folder and it's contents from a folder
and copy it in another Folder, and after delete it, how
can I do this by code

ex: copy the folder (Adress) from "c:\Client\Adress" to
the folder Employee "c:\Employee\"

Can I do this in code when the user click on a bottom ?

Thanks
Mirna

 

[Fredg]

Mirna,

Sub RenameOrMoveDb()
' Rename and/or move a database
Dim OldName As String
Dim NewName As String
OldName = "C:\Client\Address.mdb"
NewName = "C:\Employee\Address.mdb"
Name OldName As NewName
End Sub

Moves the Address.mdb from Client folder to the Employee folder.
If you wish to also rename the Address database, do so in the NewName
variable.