Just another Foxite.COM Community Weblog site
the other day i have some records from a dbf that need to be exported to an excel file. i also need to add some list-based data validation in excel via automation. i am using vfp9 and excel 2002. below is basically what i do.
export to c:\sheet.xls type xl5
loexcel = createobject('excel.application')
loexcel.columns("h").validation.add(xlvalidatelist, xlvalidalertstop, ...)
i had verified the above code works in an interactive session in the command window. but when i open the generated spreadsheet, the data validation is gone!
eventually i found out that vfp exports to excel v5 format, which does not… Continue reading