Removing line breaks from .cvs file BEFORE importing

Hi!

I am trying to creat a macro that imports a user selected .cvs file into a new sheet called Penstream, and after that it starts copying values to other sheets.

My problem is that somtimes the imported .cvs files has line breaks in them
This messes up the new sheet whit the imported .cvs data, and that in return messes up the rest of my code.
Is there a way for me to add to the macro that it removes the linebreaks from the .cvs file before it starts importing it to the main excel file?

This is what I got so far:

Please Login or Register  to view this content.

I get a Compile error: ByRef argument type mismatch and it highlights Sub Getpenstreamcvs()
If I comment out RemoveLinebreakFromCSV fname then the macro will run, without your addition