CSV reads whole file not line

One piece of code, two files, two different results ... what does that tell you? They may look identical, but they're not.

How would you have us diagnose the problem, seeing as you have the two files and we don't.

I note that the output will start with the ActiveCell. Is that intentional? Do you select a specific cell before running the macro?

Probably be useful to see the whole of the code, ideally in the workbook in context. In other words, you need to upload three files

Regards, TMS

Thank you for the quick reply.

Was hoping someone might know without me having to post the files as they contain sensitive information as this is a work project. I have removed a few key words with find and replace so the files are not identical to the originals but they still behave the same.

As for the workbook I cannot upload that as it has multiple sheets that all rely on the previous one. This is information that I am unable to remove or fudge without serious work. Below is more of the macro if that helps.

Please Login or Register  to view this content.

*Edit

I have just recreated the part of the workbook that this is happening with. I have just tested with the two files and they still behave in the same manner.

OK, as I suspected, the file structures are different. The working file has Carriage Return / Line Feed, whereas, the other file has only a Line Feed.

The following code reads the whole file into memory. It then checks for a vbCrLf and, if it finds one, it uses that as the line separator. If it doesn't find one, it uses vbLf as the line separator. It splits the date into an array of lines and outputs that directly to the sheet. It then uses Text to Columns to separate out the columns. And, finally, it autofits the columns. You might need to put a bit of work into tidying up the formatting but hey, what do you expect for free?

At least all the data is output where it should be. Incidentally, with the broken file, all the data is output ... just all across the top row

Enjoy

Regards, TMS

Please Login or Register  to view this content.

A slightly amended version of the code. Should make it easier to tailor to to match your original code.

Please Login or Register  to view this content.

Is this resolved?



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

You're welcome.