Copy a file

[Vec]

Can someone show me the code to copy a file from one directory to another? I have a file data.mdb located in C:\Program Files\QuikTrak\data.mdb and I need to code a command button that when pressed will take this file and copy it over into C:\My Documents. -


WebFusion Design
Looking Toward The Future

http://www.webfusiondesign.com

 

[MotiD]

FileCopy "SourcePath", "DestinationPath"

 

[somsally]

FileCopy will work but u can also try using FileSystemObject library since it has many more useful functions

Dim fsoObj As New FileSystemObject

fsoObj.CopyFile <Source>, <Destination>

before using FileSystemObject set the reference to Microsoft Scripting Runtime

 

[Vec]

How do I &quot;Set the reference to Microsoft Scripting Runtime&quot;? -


WebFusion Design
Looking Toward The Future

http://www.webfusiondesign.com