I don't see *.DBF among the choices in the Save As dialog. VBA lists xlDBF2,
xlDBF3, and xlDBF4 as xlFileFormat types, but all three fail. I would guess
that it's gone.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Rob" wrote in message
...
Hi,

I've run into another problem with excel 2007, the option to save as a DBF
format by VBA or using Save As seems to have been removed, is this the
case?

ActiveWorkbook.SaveAs Filename:= _
"N:\disc.dbf", FileFormat:=xlDBF4, _
CreateBackup:=False

Thanks, Rob