Import CSV file
Record a macro when you select the cell that gets the data.
And then continue recording when you use:
Data|Import External data|Import data.
engteng wrote:
How to create a button in a worksheet to import csv file automatically (when
I click the button) to the worksheet ?
ABC.TXT
Date,Time,KG,TIME (S)
08/05/2006,11:36:17,1420.998,6.1
08/05/2006,11:37:05,2131.497,2.8
08/05/2006,11:37:53,2841.996,6.8
08/05/2006,11:38:45,3552.495,8.8
Regards
Tee
--
Dave Peterson
|