I want to make a Macro that would so I can open a CSV file and it.
 

Is there anyone out there that can teach me how to do this?

Sometimes, the best way to learn is to turn the macro recorder on and then do
what you want manually.

Then turn the macro recorder off and look at the code.

Bob L wrote:

Is there anyone out there that can teach me how to do this?

--

Dave Peterson

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

"Bob L" <Bob wrote in message
...
Is there anyone out there that can teach me how to do this?