I guess that by C: you want to write to C:\ ? in Win7 you can't write to the root folder easily, instead you must write to for instance C:\temp\
>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