![]() |
|
#1
|
|||
|
|||
![]()
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 |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
shabbaranks | Excel Programming | 1 | 07-10-2014 12:18 AM |
![]() |
DBlomgren | Excel | 3 | 05-22-2014 01:28 PM |
![]() |
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 |
![]() |
mradmin | Excel | 6 | 10-16-2013 10:34 AM |