Strange CSV save

[IPOMonkey]

If i save an excel file as xlCSV using VBA and then use that file on a custom programme it is not as it should be.

But if i open it in Excel then save again choosing to leave out any incompatible features it works fine on my custom programme.

Can you save as a comma delimited file and leave out incompatible features using VBA code?

 

[rss01]

This is what I use.

objWKB.SaveAs Filename:="\\QS1047122\TO400\ZERO.csv", FileFormat:=xlCSVMSDOS, CreateBackup:=False

 

[PHV]

Have you tried the macro recorder ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[MakeItSo]

it is not as it should be

Could you specify this a bit?
What do you expect and what is the actual outcome?

Cheers,
Andy

[blue]The last voice we will hear before the world explodes will be that of an expert saying:
"This is technically impossible!" - Sir Peter Ustinov[/blue]
HP:

http://andygalambos.de