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