The program opens the text file, puts each line into a separate cell in
column 1 on a worksheet, without any parsing out to additional columns. The
statement that opens the text file is as follows:
Workbooks.OpenText _
Filename:=strPathFileName, _
Origin:=xlWindows, _
StartRow:=1, _
DataType:=xlDelimited, _
TextQualifier:=xlTextQualifierNone, _
ConsecutiveDelimiter:=False, _
Tab:=False, _
Semicolon:=False, _
Comma:=False, _
Space:=False, _
Other:=False, _
OtherChar:="", _
FieldInfo:=Array(1, xlTextFormat)
Eveything was working fine, until I ran into an HTML e-mail message that did
not contain the following line in the header (bad e-mail generation program
by the spammer?):
MIME-version: 1.0
As it turns out, if this line is missing, then all you see after the macro
runs is a completely blank worksheet with the gridlines turned off! (There
are other combinations of things that produce other results too numerous to
mention here.)
Does anyone know why the OpenText method "analyzes" the content that it is
importing, instead of simply putting each line of data into a separate cell,
as defined by the delimiter parameters (Tab, Semicolon, Comma, etc.)?
I am using Excel 2000, SP-3 on a Windows ME platform.
--
Regards,
Bill