Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I import text file of cash flow to excel file then use formula | Excel Discussion (Misc queries) | |||
Would Like to Automate Batch File Creation and Text FIle Import | Excel Discussion (Misc queries) | |||
How do I import text file, analyze data, export results, open next file | Excel Programming | |||
Import text file into excel with preset file layout, delimeters VBA | Excel Programming | |||
Get External Data, Import Text File, File name problem | Excel Programming |