Copy all text files in alphabetical order to a single text file

		Microsoft Office Forums > Microsoft Word > Word VBA
Copy all text files in alphabetical order to a single text file

FAQ

Thread Tools

Display Modes

12-24-2023, 09:45 AM

RobiNew

Windows 10 Copy all text files in alphabetical order to a single text file

Office 2016

Competent Performer

Join Date: Sep 2023

Posts: 208

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

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Alphabetical order	donnje	Word	2	07-08-2023 06:32 AM
Note books in alphabetical order	Jazz	OneNote	0	08-07-2017 10:24 AM
Right to left text, letter order gets reversed when copy pasting.	Salvia	Word	1	05-26-2013 05:19 PM
O 2007 folders & files lose alphabetical order in	John Seed	Outlook	0	02-28-2012 05:56 PM
Find in alphabetical order list	14spar15	Word	1	12-03-2011 03:01 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:54 PM.