![]() |
Importing/Exporting Blocks of Data
I've got a text file with blocks of data that consist of 20 rows, but each
row has a different amount of columns and a different amount of sizes for each item in the row. Here is an example. 74 71 65 72 72 75 73 58 66 63 63 71 71 71 76 42 10 0 1 4 1 1973 24 6 1250000 0 1991 4 17 98 0 0 0 0 0 0 0 0 179000 3000 908 0 0 0 0 0 0 0 0 0 0 14350231 0 17560676 0 0 14350289 0 14350163 0 0 0 0 0 0 12450853 0 14450301 0 0 0 0 0 0 14450297 16650373 96670803 0 14450571 0 0 0 0 0 4 190 8 3 0 0 0 0 0 - Name performance data Other Text 050105085095080090060095100100085100100 1.18 (2.6.2002) 1.18 (2.6.2002) 0 0 98 65 70 I'm looking to find a starting point on importing this data into Excel (which I can already do with a seperate program in a very round about way) and then after manipulation exporting it back into this format. I'm a little bit familiar with VB, I had to write some macros to automate the process of getting the previous files exported out of the other program into excel, as well as sending a listing of rows to seperate sheets based on criteria. Any help pointing me in the right direction would be much appreciated. |
All times are GMT +1. The time now is 05:51 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com