Problem with 'Workbooks.OpenText
 

Hi,

Good Day..

I am using the following call to open an XML document. Its a "|"
delimited file.

Workbooks.OpenText Filename:=strDataFile, Origin:=xlWindows,
DataType:=xlDelimited, Semicolon:=False, _
Space:=False, Other:=True, OtherChar:="|",
ConsecutiveDelimiter:=False, TextQualifier:=xlTextQualifierDoubleQuote,
_
FieldInfo:=Array(Array(1, 2))

When i use the extension .xml the above call fails. It doesnt return
from this statement and just hangs for ever. But if i just change the
extension to .txt it works perfect and as expected. I tried using
'Workbooks.OpenXML but it fails
File cannot be opened because:
A semi colon character was expected.
Looks like OpenXML expects a semi colon delimited file.

Any help on this will be of great help./

thanks
Jo..