SideburnsJim
New Member
- Joined
- Nov 24, 2017
- Messages
- 6
I have a slight strange request.
I have a tab delimited .txt file created daily "output_ddmmyyyy".
This file is huge - 1000 columns and about 50,000 rows.
I'd like to create a VBA program that allows you to select which .txt files to open, and then import them automatically, before saving back down as a .txt file with a limited number of variables kept.
I'd like the user to control which variables are kept in the saved output by name. For example - having a spreadsheet which individually lists which 50 variables they wanted to keep in the final output.
Does anyone have any ideas where to start for this?
I have a tab delimited .txt file created daily "output_ddmmyyyy".
This file is huge - 1000 columns and about 50,000 rows.
I'd like to create a VBA program that allows you to select which .txt files to open, and then import them automatically, before saving back down as a .txt file with a limited number of variables kept.
I'd like the user to control which variables are kept in the saved output by name. For example - having a spreadsheet which individually lists which 50 variables they wanted to keep in the final output.
Does anyone have any ideas where to start for this?