Hi,

When you say "It crashed", do you mean that an application error was raised
and Excel actually shut down? Or did you get an "method OpenText of object
Workbooks failed" runtime error?

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]


wrote:
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 ???

..