| 'Using 'Private Sub Command1_Click() 'ConCatFiles "c:\temp.txt", "c:\autoexec.bat", "c:\config.sys", _ '"c:\msdos.sys" 'End Sub 'Result - output file "c:\temp.txt" is a sum of all three source files Private Function ConCatFiles(sDest As String, ParamArray _ sInputFiles()) As Boolean Dim bTemp() As Byte, nDestFile As Integer Dim nSrcFile As Integer, i As Integer On Error GoTo ErrHandler ReDim sTemp(UBound(sInputFiles())) nDestFile = FreeFile Open sDest For Binary Access Write As nDestFile For i = 0 To UBound(sInputFiles) nSrcFile = FreeFile Open sInputFiles(i) For Binary Access Read As nSrcFile ReDim bTemp(LOF(nSrcFile) - 1) Get nSrcFile, , bTemp Put nDestFile, , bTemp Close nSrcFile Next i Close nDestFile On Error GoTo 0 ConCatFiles = True Exit Function ErrHandler: 'OPTIONAL, OR CALLER CAN JUST CHECK RETURN VALUE 'MsgBox "Unable to concatenate files.", vbCritical On Error GoTo 0 Close End Function |
Join any Number of Files into One File |
Express News India | Freelance ecommerce web development India