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