If you record a macro while doing you will get something you can boil down
to something like this.

Workbooks.OpenText Filename:=ActiveWorkbook.Path & "\" & [wbtoget],
Origin:=437, _
StartRow:=1, DataType:=xlDelimited, TextQualifier:=xlDoubleQuote, _
ConsecutiveDelimiter:=False, Tab:=False, Semicolon:=False, Comma:=False _
Space:=False, Other:=True, OtherChar:=",", FieldInfo:=Array(Array(1, 1)
, _
TrailingMinusNumbers:=True

--
Don Guillett
SalesAid Software
donaldb@281.com
"Bob L" <Bob L@discussions.microsoft.com> wrote in message
news:C52100C6-9710-4247-9FC7-ABDA0B59945F@microsoft.com...
> Is there anyone out there that can teach me how to do this?
>