PDA

View Full Version : Import CSV File to Workbook



DragonWood
01-03-2018, 08:09 PM
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
01-04-2018, 02:30 AM
Use the macrorecorder to import a csv-file (tab: Data)

Jan Karel Pieterse
01-04-2018, 08:30 AM
Have a look at www.jkp-ads.com/articles/importtext.asp (http://www.jkp-ads.com/articles/importtext.asp)