file format variant in Excel?

[openmp]

I need to save files in CVS format by automation in Excel version 8, 9, 10
and 12. This will be done by calling SaveAs so I need to know the file
format variant for CVS in these Excel versions. Where can I find this info?
Can anybody kindly help? Thanks a lot.

 

[Steve Rindsberg]

I need to save files in CVS format by automation in Excel version 8, 9, 10
and 12. This will be done by calling SaveAs so I need to know the file
format variant for CVS in these Excel versions. Where can I find this info?
Can anybody kindly help? Thanks a lot.

CVS?

CSV, perhaps?

The constant xlCSV = 6

(In 2003 but I doubt it'll be different in any other version)

To find it, open Excel, go to the IDE, press F2 for the object browser and
search on FileFormat.

 

[amcom]

Hi, Steve, you are right. It is CSV. There is a CVS store close to our office
so I confused these two.

Thanks for the help.

 

[Steve Rindsberg]

Hi, Steve, you are right. It is CSV. There is a CVS store close to our office
so I confused these two.

<G>

At least you didn't confuse it with the Walgreen's that's undoubtedly across the
street.