Im creating a short program to copy all files in a folder and then save it to another location.
is there any other way rather than using filesystemobject? how do i do that?
I changed my computer and im using windows 7. is there something i missed?
Thank you so much in advance!!!!
Private Sub cmdhp_Click() Dim mystring As String Dim flext As String Dim fso As New FileSytemObject, iCtr As Integer, dir As String Dim ServerPath, fileext As String, Extension, FileName As String Dim frmstring As String Dim SQLExec As String fso.CopyFile "C:\Test1\1.xls", "C:\Test2\file_copy.txt"