Thread: Copy all text files in alphabetical order to a single text file
View Single Post
 
Old 12-24-2023, 09:45 AM
RobiNew RobiNew is offline Windows 10 Office 2016
Competent Performer
  
Join Date: Sep 2023
Posts: 208
RobiNew is on a distinguished road
Default Copy all text files in alphabetical order to a single text file
I'm trying to copy a number of *.TXT to a single *.TXT. The files to be copied are in alphabetical order, but in the combined file the order is different. Can someone help? Thanks!
Code:
Public Sub CombineFilesRN()
Shell Environ$("COMSPEC") & " /c Copy C:\FOLDER_RN\FOLDER30\*.txt _
 C:\FOLDER_RN\FOLDER30\TXT_TXT\CombinedFile.txt"
End Sub
Reply With Quote