1. Removing Empty Rows when saving as Tab delimited text file 2.Requiring column entries.

[neitzert]

I have produced an excel file (2010) that I have formatted so users have to meet validation requirements filling out fields. When I save it to a text (tab delimited) file it saves many empty rows of data after the last actual row of data. My problem is that the program that we have to upload this into requires those empty rows be deleted. These files are going to be saved by various users. I want my excel template file to remove the empty rows when the excel file is save as a text file. I have sample excel file and text file for you to look at. Sample Text Tab delimited File.txtSample excel file.xlsx

second question - how do I force they put an entry in all columns a through h if they enter data in any column a through h? Column A is the most critical field

I spent half of today looking for answers so Thanks in Advance

[BuckoAk]

Give this a try, I Added a macro to export a Tab delimeted txt file.
This method does a line by line write and exits the sub when a blank Row is encountered.
This method prevents any unnecessary rows as you have encountered.

The file will be saved to your C:\ Drive "Exported Tab Delimited File.txt", this can be changed if you wish to do so.
If the file exists a save-as dialog will pop up asking for a new new name to prevent a file overwrite.

Your second question, have you thought about a user form?
You can set the form up so that the user has to fill in all drop down box's before the final save button will enable itself.
This method also allows for proper data entry using list options as you currently have.

If your interested let me know, I can setup a sample for you to look at.

Sample excel file RevA.xlsm

[BuckoAk]

If your happy with your answer, be sure to mark you post as [Solved].
At the Top Right of your Post You can:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

You can also give credit by clicking on the Star at the bottom left of the supporting post.