Consolidating files windows

After much gnashing of teeth and trying ineffective XLS scripts, I stumbled across a beautifully simple way to merge files using the Windows Command Line (AKA the C Prompt).Let’s say I have downloaded 3 files (file-A.csv, and file-C.csv) and I want to quickly merge them.

consolidating files windows-11consolidating files windows-39

Click the “Options” link in the lower-right corner of the dialog box to access additional options for the PDF file.

NOTE: The images may look cut off, but don’t worry.

into Excel.1) Open Excel2) When you use File Open to open the Text Import Wizard will help you import the file3) Choose Delimited4) Next5) Check Comma6) Finish This code will ask you to browse to the folder with the csv files and after you click OK in this dialogit merge all data into a txt file and then import and save it into a Excel file for you.

Copy the code below into a normal module of a workbook : Alt-F11Insert Module Paste the macro Alt q to go back to Excel Alt F8 to open your macro list Select Merge_CSV_Files and press Run There is no need to change anything in the code example for csv files to test it.

But read the Tips below the macro if you not get the result you want. Open Text Filename:=TXTFile Name, Origin:=xl Windows, Start Row _ :=1, Data Type:=xl Delimited, Text Qualifier:=xl Double Quote, _ Consecutive Delimiter:=False, Tab:=False, Semicolon:=False, Comma:=True, _ Space:=False, Other:=False Set Wb = Active Workbook Application. Save As Filename:=XLSFile Name, File Format:=File Format Num Application. Close savechanges:=False Msg Box "You find the Excel file here: " & vb New Line & XLSFile Name This example change the format of column 1 and 3 (column number, format number)This are the format numbers 1: General2: Text3: Month-Day-Year4: Day-Month-Year5: Year-Month-Day6: Month-Year-Day7: Day-Year-Month8: Year-Day-Month9: Skip column Replace If you use it for txt files then you can change the delimiter or maybe you want to use Fixed Width.

Option Explicit #If VBA7 Then Private Declare Ptr Safe Function Open Process Lib "kernel32" _ (By Val dw Desired Access As Long, _ By Val b Inherit Handle As Long, _ By Val dw Process Id As Long) As Long Private Declare Ptr Safe Function Get Exit Code Process Lib "kernel32" _ (By Val h Process As Long, _ lp Exit Code As Long) As Long #Else Private Declare Function Open Process Lib "kernel32" _ (By Val dw Desired Access As Long, _ By Val b Inherit Handle As Long, _ By Val dw Process Id As Long) As Long Private Declare Function Get Exit Code Process Lib "kernel32" _ (By Val h Process As Long, _ lp Exit Code As Long) As Long #End If Public Const PROCESS_QUERY_INFORMATION = &H400 Public Const STILL_ACTIVE = &H103 Public Sub Shell And Wait(By Val Path Name As String, Optional Window State) Dim h Prog As Long Dim h Process As Long, Exit Code As Long 'fill in the missing parameter and execute the program If Is Missing(Window State) Then Window State = 1 h Prog = Shell(Path Name, Window State) 'h Prog is a "process ID under Win32. The best thing you can do is to record a macro when you import one txt file manual.

Simply open the command line by typing the word “run” into your Windows Start Menu, or execute the file at C:\Windows\System32\ Next, direct the command line to the directory that contains the individual files you want to merge.

The command line begins in the C:\Windows\System32\ directory.

You might have to rename them so they get sorted the way you want. Select “Microsoft Print to PDF” from the “Printer” drop-down list.

Once you have your images in the right order, select them all and right-click on them. If you don’t see that option in the list, see the next section for information on activating it. Use the right and left arrow button below the image to scroll through the images that will be added to the PDF file.

This is a trick which can save you a lot of time when working with a dataset spread across multiple CSV files.

Tags: , ,