Hi All,
I need some help with an Excel Automation process.
I am creating an Excel worksheet from a VFP7 .prg OK and populating it OK from a .txt file, using the QueryTables.Add method. Everything works except being able to change the column format of a table. I then save the worksheet as a dbf4 formatted .dbf.
The syntax formt for the column format taken from the Excel macro is:
TextFileColumnDataTypes = Array(2,2,2,2,2,2,2) representing a 'Text' format.
I need to change one of those columns to a date format and another to numberic.
VFP does not like the Array() bit.
I have tried setting up an array and entering:
TextFileColumnDataTypes = @arrayname
and it still doesn't like it.
Any help would be appreciated.
Regards,
Bill
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