CSV to XLSX Not Working Anymore

Greetings,

I wrote this code to convert csv files to xlsx which worked well for the first set of about 100 files. I just got a second batch from our vendor and I tried converting them but am now getting the "Excel cannot open the file 'SomeName.xlsx' because the file format or file extension is not valid. Verify that the files has not been corrupted and the file extension matches the format of the file." Not sure what broke. Please help. I would also be open to code that can convert all the csv files in the folder to xlsx. But that is not a priority.

Please Login or Register  to view this content.

Can you upload a sample of a csv file that was converted, a sample of a csv file from the new batch, and a copy of the workbook which contains the code. Thanks

I am sorry I can't upload the original csv files as they contain data only sent to us by the vendor upon a subpoena. I am attaching a sample csv file that I saved as csv and converted it to xlsx. All three attached here. Thank you for your help.

Hello Holger,

Thank you. That did it. Yes, I am new to VBA learning it by recording macros and from experts like you.

I have one more posting on the forum for copying data, can you help with that please.

Regards,

Kas

Please Login or Register  to view this content.

Am not allowed to post on multiple forums. Are they all connected.

You are allowed to post on multiple forums. However, you are expected to tell everyone where you have posted so they don't waste time working on a problem that has been solved elsewhere.

And be sure you will be found out as most of the people who answer questions here also answer questions on ALL the other forums.

Awesome, thank you.