Save excel doc as dbf with VBA

[gads]

Hi all,
Does anyone know how save excel doc as dbf file from VBA Code?
I use

ActiveWorkbook.SaveAs strnewfile, xlNormal.
But DBF?

Thanks a lot

 

[scking]

If you record a macro and perform the action then look at the recorded macro you will see the code that was developed. Make sure you have selected a range.

Range("A1:A2&quot.Select
Range("A2&quot.Activate
ActiveWorkbook.SaveAs Filename:="G:\SDV\MGMT\Book1.dbf", FileFormat:=xlDBF4 _
, CreateBackup:=False

---------------------
scking@arinc.com
---------------------