Import multiply CSV files

Hi,

I have got a few CSV file in one folder and I use code (et the end of this post) to import this files:

I changes .TextFilePlatform = 437 on xlWindows, set .TextFileSemicolonDelimiter = True and switched off .TextFileOtherDelimiter = False

Almost all works good, but if one cell in CSV file contains a F letter, macro insert an empty cell and remove F. Example:

CSV file
Mark;Smith;Poland
Peter;Friend;Poland

will be import:
Mark;Smith;Poland
Peter;[HERE IS AN EMPTY CELL];riend;Poland

Why it is works like that? I was looking for an answer in internet but without result.

Best regards
Grzegorz

Code from link I give below:

Please Login or Register  to view this content.

Code Tags Added
Your post does not comply with Rule 2 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)

these are our forum rules: https://www.excelforum.com/forum-rul...rum-rules.html

Read them and understand them. Failure to comply with them on a consistent basis and you will risk banishment from this forum. We take our rules compliance seriously.

Now I understand, but You change your post (cause you are admin ) Firstly you wrote about Rule 3.

I am sorry...

Grzegorz

Moderator Response: My apologies. I clicked on the wrong rule and it took a few minutes to correct. Welcome. --Alan