I am using Excel 2002 and Windows XP.

I have an Excel Macro that works just fine in Excel 97. Now our
department has Excel 2002 on XP platform. The same macro that worked
before, does not work now.

As a test, I recorded a key stroke macro using Excel 2002 on XP. Then I
ran the key stroke macro in VBA mode. It crashed. Below is the line of
code. For whatever reason, Excel 2002 on Windows XP does not like
Workbooks.OpenText

Workbooks.OpenText Filename:=lcFilename2, Origin:=xlWindows, _
StartRow:=1, DataType:=xlDelimited,
TextQualifier:=xlDoubleQuote, _
ConsecutiveDelimiter:=False, Tab:=False, Semicolon:=True,
Comma:=False _
, Space:=False, Other:=False, FieldInfo:=Array(Array(1, 2),
Array(2, 5), _
Array(3, 2), Array(4, 2), Array(5, 2), Array(6, 2), Array(7,
2), Array(8, 1), Array(9, 1), _
Array(10, 1), Array(11, 1), Array(12, 1), Array(13, 1),
Array(14, 5), Array(15, 5), Array( _
16, 2), Array(17, 2), Array(18, 2), Array(19, 1))

Can anyone help ???

...