Text File Manipulation
I have a question regarding reading and writing text files. I have text files which contain data results from a structural analysis program. The files vary in size according to the size of the problem and have a format similar to this
0 1 2
3 4 5
6 7 8
The way I import the data into excel at the moment is to delete all the intro and summary data from the text file, then open the file up with excel and paste it into my sheet that has the macro to process the data.
I have been trying to find out the best method to automatically prepare and import the data. I have read that excel has some text file reading and writing capabilities. Would it be a viable option to use VBA to do this process or is it better to try and use another program ported with excel. Python maybe?
You can use I/O commands in VBA.
How do you determine intro lines and summary lines?
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1