This maybe a really silly questions but this problem has been bugging me for a while now and I still can't find an answer.

I have create a macro which takes everything in a worksheet and turns it into a csv file. The problem is, one of my fields contains quotes (i.e. ' '). When the CSV is created, this field becomes blank rather than keeping the quotes in place. I have tried " ' ' " but then I get the output " ' ' " in my CSV and i only want ' '.

Does anyone have any ideas on how i can solve this problem?

Thanks

Sam