Import CSV File to Workbook

[DragonWood]

Greetings,

I am trying to import a CSV file. The location and name of the file will change, as will the number of rows to be imported. However, the columns will always be A:G and the rows will be a minimum of 1:10.

The information will be imported to a page in my workbook called “Temperature Log”. I want to only paste the values from the CSV file so the formatting in my workbook remains.

I’ve searched the site here and can’t find anything about this.

Thanks.

[snb]

Use the macrorecorder to import a csv-file (tab: Data)

[Jan Karel Pieterse]

Have a look at www.jkp-ads.com/articles/importtext.asp