Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Merging or Adding two .csv files
Another:
Sub AppendFiles() Dim SrcFiles As Variant, CurrSrc As String Dim DestFile As String, Counter As Integer Dim TextLine As String SrcFiles = Array("c:\File1.txt", "c:\File2.txt") Open "c:\dest.txt" For Output As #1 For Counter = 0 To UBound(SrcFiles) Open SrcFiles(Counter) For Input As #2 Do While Not EOF(2) Line Input #2, TextLine Print #1, TextLine Loop Close #2 Next Close #1 End Sub -- Jim Rech Excel MVP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
merging and adding cells | Excel Discussion (Misc queries) | |||
merging files | New Users to Excel | |||
merging zip files! | Excel Discussion (Misc queries) | |||
merging two files | Excel Discussion (Misc queries) | |||
Merging or Adding two .csv files | Excel Programming |