Exporting worksheets as Tab-Delimited text .vbs

I have an excel workbook with 3 different worksheets contained, these sheets are labeled:

Generic, CoBrand, TriBrand what I would like to do is have a script reference the excel workbook and save each sheet as a separate tab-delimited text file.


But to only export the Fields that have data (check against blank spaces or characters).

we will be using the same workbook for the headers and deleting the data daily, I know that excel will still act as though data is within those fields and I can't use it if it saves multiple blank lines in the text file.

Thanks in advance,
Best regards,
Joe

"skip blanks" sounds like an easy request and it may be, but people say one thing and mean another when they say things like this.

Please provide a sample workbook that shows data that needs "evaluating" on all 3 sheets and then examples of the resulting CSV files that you would like to see as a result of that sample data.

In other words, do it once by hand on a small but demonstrative set of data so we can see the start and finish lines clearly. Do not dumb down the process too much, make sure the data demonstrates all the problems to overcome and your solutions manually accomplished.

Click GO ADVANCED and use the paperclip icon to post up a desensitized copy of your files.

Meanwhile:

I have a macro that may be "ready to use" for exporting all sheets in an Excel file each to their own CSV file.

Sheets to CSVs

This would be the basis for any assistance I provide, adding in whatever code is needed to exclude the rows you're going to demonstrate.

Your sample TXT file appears to be a version of the GENERIC sheet from the XLS file. Unfortunately, nothing at all regarding blanks.

You've got some stray garbage in cells outside your used range. Excel uses these stray cells when you save a sheet as a TXT file.

You can run this macro on your workbook and it will clear all the stray stuff from outside the data range on each sheet.

Please Login or Register  to view this content.

Then when you save the GENERIC sheet it won't have those 10 blank rows at the end.

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.