Help with exporting to a .csv

[SteveD]

Hi,

I need to format a cell using a macro so that when I save the sheet to a .csv file and I view it in notepad I get ...,"",... for that cell(where ... is the data before and after the two quotes)

I've tried:
ActiveCell.FormulaR1C1 = ""
When I export I get two commas next to each other: ...,,...

Then I tried:
ActiveCell.FormulaR1C1 = """
But the code was auto corrected to put in four quotes. The VB editor would not let me have just 3.

Finnaly tried:
ActiveCell.FormulaR1C1 = """"
Result after export: ...,"""",...

Can someone please let me know how I can just get the 2 quotes?
Thanks!

 

[Mark W.]

This message was edited by Mark W. on 2002-02-21 13:14

 

[SteveD]

Thanks... but

Now when I export I receive:
...,"""""",...

I'm looking for:
...,"",...

Thanks for your help!

 

[Mark W.]

Steve, I don't think it can be done!!! What are you trying to achieve?

 

[SteveD]

I'm exporting this sheet so I can query it against a database. I need to link this field to an existing field whose value is "".

Anyone else have any ideas?

 

[Mark W.]

I'd just enter " into the cells where you want "". Save as .CSV and then edit the file replacing all occurances of "" with ".
This message was edited by Mark W. on 2002-02-21 13:41

 

[SteveD]

Ya, I thought of that.
I was hoping that I would have Excel do this for me. I'm trying to wirte this to hand it off and want to make it as fool proof as possible.
Thanks again.

 

[Juan Pablo González]

Don't know if it'll help, but try replacing the "" with vbNullString

_________________
Regards,

Juan Pablo G.
MrExcel.com Consulting
This message was edited by Juan Pablo G. on 2002-02-21 17:26