Import mutiple cvs-files into one sheet.

Hi,

I want to automate the import of multiple cvs-files(50+) to one sheet with same settings for all (i.e TextFilePlatform, Delimiters) and i want a new row where the filename of the imported data came from is presented.

Is this possible in VBA? I dont have any vba-skill :/

Hi!---spaced out for a "while" on this issue I found https://sites.google.com/a/madrocket...svs-to-1-sheet
wich is exactly want BUT I have to change the delimiter from "," to ";". How do I do that in this script?

You could try adding the line

Please Login or Register  to view this content.

before the last line in the macro for importing csv files.

Csv files value will not be changed only the data in active excel sheet.

Alf

I just want change the delimiter from comma to semicolon, so the values break up in columns at the semikolons instead of the commas in the import.

You need to set the parameters right i.e.

Please Login or Register  to view this content.

I would recommend you to record a macro importing one csv file to excel using the import wizard.

Start by clicking "Record Macro" in "Developer's" tab. Then click "Data" tab and click "From Text" icon. Click on a csv file you wish to import, then button marked "Import".

This will start the "Text Import Wizard". First step check that radio button "Delimited" is activated. Then click next. Select "Semicolon" and check that "Comma" is not activated.

Click "Finish" and import result to say cell A1. Activate "Developers" tab and click "Stop Recording". Click on "Macros" icon and select "Edit". Copy macro code and post it then a forum member will help you to write a macro that loops through all files in that folder. Imports data from csv files and splits data using semicolon as delimiter.

Imported data should start with csv file name, data split in columns based on semicolon. Then an empty row and then comes the next csv file name and data?

Alf