I am programming a VBA Macro and it is giving me HELL! I basically am
checking through each record and formatting the text in a certain way. The
text is being exported into a text file and saved in the same directory as
the excel spreadsheet. I used select statements to check through each
record. Each field has a text string before displaying the record. When the
field is null, the text string shouldn't even show up on the text file. But,
my problem is it still displays the text string within the text file. How do
I not display the text string for each field when it is a null field?