![]() |
|
#2
|
|||
|
|||
|
A simpler way:
1. Read your original table (or values from columns you want to transfer) into (starting from row from where to read data without headers) array variable; 2. Create an empty text file with a name you want on destination you want; 3. In For cycle (from 1st row of array to last one), read 1st array row and create a string form all array values in this array row, plus a code for next row at end of string; 4. Write the gotten string into text file; 5. Repeat the cycle of p3 and p4 until end of For cycle; 6. Save the text file. |
| Tags |
| excel 2021, vba |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Importing\convert a bin file to Excel
|
shabbaranks | Excel Programming | 1 | 07-10-2014 12:18 AM |
How do you convert a csv file to appear properly in Excel 2013?
|
DBlomgren | Excel | 3 | 05-22-2014 01:28 PM |
Convert excel file 2010(64 bit) to 2003
|
Tyberian1988 | Excel Programming | 1 | 03-10-2014 11:39 PM |
| A serious problem in integrating text file with an Excel file? | mradmin | Excel | 12 | 10-25-2013 07:43 AM |
How to convert a text file to an Excel file with the data format automatically?
|
mradmin | Excel | 6 | 10-16-2013 10:34 AM |