format all files in a folder

[maxxino]

Hi,

I have a dataset consisting of more than 50k .csv files, all files are in the same format now and I need to perform some procedures on all of these files (text to columns, basic calculation - summary of certain columns, etc.). I googled some codes, but none worked for me, could you pls help me? I have Office 2013.

I wanted to attach excel file with the orginal sample and the requsted adjusted sheet, but I could not upload it here on the website due to "Manage attachments" function (I have chosen the file from my PC, but then the the uploading seemed to be infinite), thus I used Czech website:

http://ulozto.cz/xS7SsCpE/vba-sample-xlsx

You may just push "Stáhnout", it means download.

I will be very grateful for any kind of help you can provide. Thanks in advance.

DB

[snb]

Answer provided here: http://www.vbaexpress.com/forum/show...l=1#post325010

[maxxino]

Hi,

yes, but the answer did not work for me, thus I tried to ask on other website. Is any information that you would need from me to improve the code??
Ofc I will be very glad to provide it.

Kind regards,
DB