Data shift with the letter "F" in csv files; macro that uploads multiple csv files

My objective of the following macro is to import a number of csv files into one workbook as different worksheets within that workbook. Those worksheets are to be named the name of the file that is being imported. Here is the crux - any text that contains the letter "F" causes a shift in the data, almost as though I have specifed that the delimitter is the letter "F" (which I have not):

Please Login or Register  to view this content.

I have attached one of the csv files where I have added a number of extra letter "F" in the text. What am I missing??

13C406C_QCDATA.csv


When the files are selected in excel for opening (and the macro is not run) all data is placed in the appropriate fields without any problems.

Jerry, I found a solution to the problem using my own code that I will present. I appreciate you sending the alternate macro and will check it out! Here is the revision that I made:

Please Login or Register  to view this content.

I don't understand why just setting the comma delimiter to true would not work, but it didn't. Setting it to false, and then specifying the other delimiter as a "," did work however. I hope this helps any others that may have found a similar problem.