Access 2007 still supports .SaveAs DBF. You could write an add-in to
automate opening the Excel in Access, then .saveAs/.Export as dbf.
Or use the free Open Office.

NickHK

"weschester" wrote in message
...
Is there a plan to add .dbf 'save as' fuction back into Excel in a (near)
future update? Many of us who use mapping software need this function.
Any
news, help or third-party solution you could provide?
The more steps you require to complete a task, the more resistance there
will be from others who come after us to upgrade to 2007. if I had known
this would be a problem I would not have upgraded.
Please tell me all hope is not lost.


"Jon Peltier" wrote:

User statistics feedback must have indicated that few users made use of
DBF
format files.

Unfortunately the user statistics were not collected from users of
earlier
versions than 2003, nor from people who didn't activate it (mostly power
users), nor from within companies whose IT departments disabled user
statistics feedback

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


"Rob" wrote in message
...
Thanks Jon, it's good sometimes to check these things out but why
anyone
would remove such an option is beyond me, I have 20 or more
applications
that use Save As DBF which now fail. Oh well, reinstall 2000!

Regards, Rob

"Jon Peltier" wrote in message
...
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