Tag Archives: multiple csv files

Import multiple csv files to 1 column in 1 sheet

Application.ScreenUpdating = False Worksheets(“Sheet1″).Cells.ClearContents Dim qry As QueryTable Dim FilNams As Variant Dim FilNamCntr As Long Dim strQryName As String Dim LastRow As Long Dim ContainerWB As Workbook Dim msgString As String Dim rng As Range Dim iCol As Integer Dim lastCell As Integer FilNams = Application.GetOpenFilename(FileFilter:=”Text Files (*.csv),*.csv”, _ Title:=”Select Textfile to Import”, _ […]

the web designer group uk
the webdesigner group logo

Close Button

Web Site Designed by

The Web Designer Group