Try


Macro1 Macro
' Macro recorded 5/17/2006 by LTC Jocius
'

'
Workbooks.OpenText Filename:= _
"C:\Documents and Settings\Super_User2\Desktop\_6222CD1May06.dat",
Origin _
:=437, StartRow:=1, DataType:=xlDelimited, TextQualifier:=xlDoubleQuote
_
, ConsecutiveDelimiter:=False, Tab:=False, Semicolon:=False, Comma:= _
True, Space:=False, Other:=False, FieldInfo:=Array(Array(1, 1)),
TrailingMinusNumbers:=True
End Sub


--
mudraker
------------------------------------------------------------------------
mudraker's Profile: http://www.excelforum.com/member.php...fo&userid=2473
View this thread: http://www.excelforum.com/showthread...hreadid=543164