How can I load a csv as a sheet of the current workbook?

Question

How can I load a csv as a sheet of the current workbook in Excel-vba 2007 ?

possible duplicate of [Open csv file via VBA (performance)](http://stackoverflow.com/questions/9564908/open-csv-file-via-vba-performance) — assylias, Mar 26 '12 at 13:54

mattboy · Accepted Answer · 2012-03-26T20:19:17.817

1

I suppose you would need to save it as a csv file. Something like this:

ActiveWorkbook.SaveAs Filename:="c:\whatever.csv", FileFormat:=xlCSV

See here for more on how to use the SaveAs method.

Is this what you're after?

EDIT

Or if what you're after is to import a csv file like Jerry answered but with VBA, then I believe you use the OpenText method.

Workbooks.OpenText FileName:="c:\whatever.csv"

edited Mar 26 '12 at 20:19

answered Mar 26 '12 at 18:56

mattboy

score 0 · Answer 2 · answered Mar 26 '12 at 20:09

0

You would use the Data > Import data > (choose file) > import options > [x] New Worksheet

answered Mar 26 '12 at 20:09

Jerry Beaucaire

2 Answers2