Hi guys,
I'm trying to import multiple csv file into an existing worksheet (sheet1) within an existing workbook (WBTest). All csv files have same structure and have semicolon as delimiter. Csvs don't have header.
The content of the csvs should be imported starting from B6 cell. Before importing I need to clear the range below B6 and for all the columns.
Once all data are imported I must copy formatting and formulas from an existing row (row2).
I'm able to clean the range but I don't get how to merge them in one and how to set semicolon as delimiter. Below the code for cleaning. For now I found a solution using powershell but I would like execute all the steps using a vba script.
Do you have any suggestion on how to import multiple csvs?
Many thanks in advance guys!
I'm trying to import multiple csv file into an existing worksheet (sheet1) within an existing workbook (WBTest). All csv files have same structure and have semicolon as delimiter. Csvs don't have header.
The content of the csvs should be imported starting from B6 cell. Before importing I need to clear the range below B6 and for all the columns.
Once all data are imported I must copy formatting and formulas from an existing row (row2).
I'm able to clean the range but I don't get how to merge them in one and how to set semicolon as delimiter. Below the code for cleaning. For now I found a solution using powershell but I would like execute all the steps using a vba script.
Do you have any suggestion on how to import multiple csvs?
Many thanks in advance guys!
VBA Code:
Sub DeleteRowsBelow()
Worksheets("backup").Rows(6 & ":" & Worksheets("backup").Rows.Count).Delete
End Sub