I just found this function:
Workbooks.OpenText(Filename, Origin, StartRow, DataType, TextQualifier, ConsecutiveDelimiter, Tab, Semicolon, Comma, Space, Other, OtherChar, FieldInfo)
has anyone had any experience using it?
"DataType Optional Variant. Specifies the column format of the...