...
- 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
...