Hello ... here's my issue. I am trying to convert several different spreadsheets in a workbook to fixed width text files. The actual data changes with each user.
When I run the Macro it appears that the .txt file is created correctly. I do a manual check of the data in WordPad and the data looks correct except for some blank rows which I manually delete up to the last record then I resave the file.
The problem appears when I use a utility (WVutil) to create a .dat file from the .txt file. The utility only reads or sees one record and stops there.
Here is what I need to occur:
1. I need to always remove Column J2 (SEGX)
2. I need to delete columns that may contain garbage.
3. I need to delete rows that may contain garbage/blanks OR better yet not read past the
last record (then I would not need to manually delete blank lines).
I’ve attached a copy of the Macro I used for this particular spreadsheet. I am a novice trying to learn my way through this. Any help you can provide would be greatly appreciated.
Please Note: I manually copy the excel spreadsheet from a workbook into a new workbook which has the macro. I’ve created a button on the new spreadsheet to push to run the Macro.