Import CSV file
 

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

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