...
- Download the script modWriteDBF.bas
- In Excel, open the Visual Basic Editor (Tools -> Macro -> Visual Basic Editor)
- In the right column, right click on "VBAproject (PERSONAL.XSL)" (Read this if there is no PERSONAL.XLS )
- Select "Import File", and select the downloaded script
- Select menu "Tools" -> "References"
- Make sure that the newest "Microsoft ActiveX Data Objects Library" is selected (probably 2.7 or 2.8)
- Go back to Excel, right-click on an empty space on the toolbar, select "customize"
- In the tab "Commands" select "Macro's" in the left display
- In the right display, select "Custom button". Drag this button to a location in the toolbar
- Right-click on the button, select "Assign macro"
- Select "PERSONAL.XLS!SaveAsDBF"
- It is also possible to change the button image and text here
- Close the customize screen
...
- 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.
- In case of very large tables, you can get the error "field will not fit in record". The total number of characters or bytes in the whole table seems to be the problem. It is not solved yet.