We help IT Professionals succeed at work.

VB6 copy and move

HKFuey
HKFuey asked
on
331 Views
Last Modified: 2012-05-07
I have some VB6 code that copies files over the network.
I want to use this to copy SQL backup files which are in this format: - Database_backup_200906301200.bak
Does anyone know of a simple solution that allows me to copy all the items in a folder to another and then move the copied files so they are not re-copied next time the program is run?
Option Explicit
Dim NetFile As String
Dim HDFile As String
 
 
Sub main(HDFile As String, NetFile As String)
 
    On Error GoTo Errtrap
    FileCopy NetFile, HDFile
    
    Exit Sub
Errtrap:
    Select Case Err
        Case 91 ' not set
        Resume Next
        Case 53 ' file not found
        Resume Next
 
    Case Else
        MsgBox Err & "  " & Err.Description
 
        End
        Exit Sub
    End Select
End Sub
 
Private Sub Form_Load()
 
    NetFile = "\\files\users\andy\temp\Test.bak"
    HDFile = "c:\temp\test.bak"
    
    main HDFile, NetFile
    End
    
End Sub

Open in new window

Comment
Watch Question

Author

Commented:
I have already looked at that here: -
http://articles.techrepublic.com.com/5100-10878_11-1050078.html (posted by Angelll)
If I put this in my code 'Dim fso As New FileSystemObject' I get an error 'User Type not defined'

Author

Commented:
OK got a bit further, I added the reference Microsoft Scripting Runtime

Author

Commented:
I can get the FilesystemObject to work, does anyone know the syntax to copy/move all the files in a folder?

Author

Commented:
OK I've done it, code below

Option Explicit
Dim MovFile
Dim NetFile As String
Dim HDFile As String
 
 
 
Sub main(HDFile As String, NetFile As String)
Dim fso As New FileSystemObject
 
    On Error GoTo Errtrap
 
    fso.CopyFile NetFile, HDFile
    fso.MoveFile NetFile, MovFile
    
    Exit Sub
Errtrap:
    Select Case Err
        Case 91 ' not set
        Resume Next
        Case 53 ' file not found
        Resume Next
 
    Case Else
        MsgBox Err & "  " & Err.Description
 
        End
        Exit Sub
    End Select
End Sub
 
Private Sub Form_Load()
 
    NetFile = "\\files\users\andy\temp\*.*"
    HDFile = "c:\temp2\"
    MovFile = "\\files\users\andy\temp\Mov\"
    
    main HDFile, NetFile
    End
    
End Sub

Open in new window

CERTIFIED EXPERT
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
Thanks for the help!
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.