General information
Category:
Coding, syntax & commands
Title:
Excel Ole Automation
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only