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

D

Dave Peterson

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.
 
D

Don Guillett

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
 
Top