Monthly Archives: May 2007

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.workbooks.open("c:\sheet.xls")
loexcel.columns("h").validation.add(xlvalidatelist, xlvalidalertstop, ...)
loexcel.activeworkbook.save()
loexcel.quit()

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