I have been "upgraded" to Excel 2007 which I discovered does not save to DBF format
So I put together the attached Excel 2007 add-in to add this functionality back in. Once activated, it will add a "dBASE IV DBF" menu item in the Office menu Save As list. It works mostly like the Excel 2003 save as DBF.
To install, unzip the attachment to your "Documents and Settings\UserName\Application Data\Microsoft\AddIns\" folder and activate it in Excel.
One issue is that the Jet driver ignores the data types and uses what it thinks is best instead. A work-around would be to reopen the table with the VFPOLEDB driver and alter table the columns to what you want.
Hopefully people will find this more useful than copying the data to Access and exporting from there.
Usually this error is caused by a missing library reference.
Here are suggested steps to solve this problem. They might not be exact as I don't have Excel 2007 where I am right now.
1. Open the Visual Basic editor (Alt + F11 ???)
2. Open Module1 in SaveDBFIV
3. In the Tools menu choose References.
4. If there are any items in the list that are marked as MISSING, deselect them. (Write them down for future use)
5. Save and try again
6. If that does not fix the problem, you might need to try and find a similar library to the missing one in the list and select it.
I'm not sure how Excel labels things in French, but hopefully it is similar.
If this doesn't work, please post which references were labeled MISSING. If there were no missing references, please post all of the references that are selected.
Thanks it works now, with some constraints:
If I edit and existing dbf I need to give a new name - it couldn't replace the existing one. Also, necessary to go through the "Save as..." menu to save change.
I downloaded upgraded "SaveDBFIV.zip", extracted under proper addin folder and activated under excel2007. It is seen under active application add-ins under excel options. No missing entries found under visual basic references. But still it is not working. There is no "dBASE IV DBF" menu item in the Office menu Save As list. Please HELP.