Hi guys,
I've been fiddling with VBA again, and seem to have come unstuck.
I work at a cabinetmakers, and I'm writing a macro to export a list of
parts to a program that talks to our saw. The program uses a CSV file
to read in all the sizes, descriptions etc etc.

Problem is, that i need one of the fields to equal " " (with the
qualifiers)
I've tried the following, and countless others, but these seem to be
the closest

Workbooks(Paste_Book).Activate 'D = " " (Material String
Field 2)
Range("D1:D" & bot2).Value = """ """

Workbooks(Paste_Book).Activate 'D = " " (Material String
Field 2)
Range("D1:D" & bot2).Value = " "

The first looks right when I open the xls file (before it exports to
csv), but after the exporting, it gives me """ """ in the cell

the second gives me a space only in excel, and after the exporting,
also leaves me with only a space... and no qualifiers

hope that made a little bit of sense, and i hope someone here can help.

thanks in advance!