Save file as CSV - Comma Separated

[dipsy]

Sub createPlanID()

Sheets("2004Data").Copy
ActiveWorkbook.SaveAs Filename:= _
"C:\New\PlanId.csv" _
, FileFormat:=xlCSV, CreateBackup:=False

End Sub

The following VBA code creates the Plan ID file. However
when I go to open the file it gives me error - SYLK: File
format not valid.

I want to take a sheet from one book and save it as a
newbook as a Comma Separated file.

Thanks.

 

[Malcolm Graham]

You might try recording the keystrokes to save the
worksheet as a .csv file and see if that works.

MG

 

[Guest]

.. . .

However when I go to open the file it gives me error -

SYLK: File format not valid.
.. . .

This occurs because the file starts with an "ID" string.
Let me explain better, if you have a file where the first
line is like the follow:
ID, NAME, ADDRESS
when Excel find "ID" as the first two digit of a text
file, it think that it is a SYmbolic LinK (SYLK) formatted
file...

Hope this answer.
M.Rossi
mario.red .n.o.s.p.a.m. @email.it