http://answers.microsoft.com/en-us/office/forum/office_2007-customize/save-as-dbf-in-excel-2007/1a4c2f65-b560-4183-8de1-1cf275c42c38



>Hi,
>I have a program which can successfully have to SaveAs a Excel file to DBF file run on WIN xp using Excel 2003,
>
>

>#DEFINE xlDBF4 11
>m.tcDbFile="C:W130314.DBF"
>.....
>loExcel.ActiveWorkbook.saveas(m.tcDbfFile, xlDBF4)
>

>
>But if I run on 64bit Win 7 using Excel 2007, the above code have an error and cannot create the dbf file.
>
>Why ?
>
>Please advise.
>
>Thanks.
>
>Derek Yim