I want to import a csv file via VBA which contains linebreaks in datafields. Each datafield is using double quotes. I've tried to use chr(13) instead of chr(10) but this doesn't work at least in Excel 2007. Also I can't use UTF-8 or something like this.
I know there is a possibilty to use a placeholder and replace it via search/replace, but I don't like this solution because it's only a workaround.
Are there any other possibilities? (please post some code)
I've attached an example.