Description
This tool is a simple macro which can be added to Excel to save the active sheet as DBF file. The DBF file is in a FEWS-readable format. When following the instructions below, the macro can be started by pressing a button in the menu bar.
Installation
- Download the script modWriteDBF.bas
Known issues
- Sometimes the content of cells with many characters are not correctly written in the dbf. It is not known why this happens. Solution: try again (maybe multiple times).
- Sometimes during the running of the script the Visual Basic Editor pops up and the script stops running. No problem, just press F5 and the code continues.