>I can not get excel to save a excel worksheet as a DBF file via VFP.
>Any help would be appreciated.
>
>Excel Worksheet SaveAs method syntax:
>expression.SaveAs(Filename, FileFormat, Password, WriteResPassword, ReadOnlyRecommended, CreateBackup, AddToMru, TextCodePage, TextVisualLayout)
>
>Note: the TextCodePage and TextVisualLayout parameters do not apply the the U.S. version of Excel
>
>my Code:
>ox.Sheets('Changes').SaveAs('c:\temp\test.dbf','xlDBF4' ,' ', ' ', .f. , .f. , .t. )
>
>
>VBA Macro to save as DBF file as it appears in Excel:
>
>ActiveWorkbook.SaveAs FileName:="C:\temp\test.dbf", FileFormat:=xlDBF4, CreateBackup:=False
xldbf4 is not a string, is a constant with the value of 11. try this:
ox.Sheets('Changes').SaveAs('c:\temp\test.dbf',11,' ', ' ', .f. , .f. , .t. )
Saludos,
A.G.P.
---------