Error Reading Text File Line By Line

Hi All,
I am reading eml files and write it to Excel.
I use method reading line by line as follow:

Please Login or Register  to view this content.

The macro working fine so far but in certain case I got error
Capture.JPG

And error was on line

Please Login or Register  to view this content.

The input file is

Please Login or Register  to view this content.

It seems that “=” sign at the beginning of line creating the problem.
After modify the code I got it work wihout any error.

Please Login or Register  to view this content.

My Question is: Are there any other way (better way then what I got here by adding “-“ sign at the beginning of the line which is start by “=” sign) to handle such a case?
Your helps is greatly appreciated.

Regards,
Benny

Have you tried

Please Login or Register  to view this content.

Hi Jindon,
I try your suggestion and it works fine for writing content of text file to excel.
Moving a head one step, let say that I will read file one and write it in column 1 (several lines start with “=”). Next I read file two and write it in column 2(still with several line start with “=”).
(for some reason those lines start with “=” are the same)
I then compare column one and column two to get what is similar on both colums and the result written in column 3.
What I notice so far:

1. While using “’” & Data during reading text file and then compare column 1 and column 2 to get siimilarities I then fail to spot similarities in the line start with “=” which is already modify to “’” & data eventhough those lines are exactly similar in the reality.

2. While using “-“ & data during reading text file and then compare column 1 and column 2 to get siimilarities I then fail can spot similarities in the line start with “=” which is already modify to “’” & data.

Any idea why? I have been searching for hours but still couldn’t find any clear answer.


Regards,
Benny