Recent content by M.Enders

  1. M

    VBA to Copy a file and Rename it

    Thank you so much. The code that I ended up using is as follows: Dim FSO As New FileSystemObject Dim FolderPath1 As String Dim FolderPath2 As String FolderPath1 = Me.Text139.Value FolderPath2 = "C:\RASAP\Closeout\" & Me.Combo133 & "\" & Me.Combo131 & "_" &...
  2. M

    VBA to Copy a file and Rename it

    JHB. my problem is I simply do not know the code that will allow me to rename the file once it has been copied into the folder.
  3. M

    VBA to Copy a file and Rename it

    Hello, I am trying to have access VBA copy a folder and then rename it to a naming convention based on the combo boxes. The need naming convention should be me.combo131 & "_" & me.combo133 & "_" & me.combo135 & me.combo137 Help me Dim FSO As New FileSystemObject Dim FolderPath1 As...
Top Bottom