>Greetings,
>
>I am using VFP9 SP2, to create spreadsheets in Excel 2007. Issuing the following command is causing an error number 1429: "Unable to get to the SaveAs property of the Workbook class." It also reports "Foxcode table not found, is not correct version, or is incompatible." The error is occuring with a shared application on a network.
>
>oExcel.ActiveWorkbook.SaveAs('&lcFilename..xls')
>
>Everything has been working fine up to now. This is the first time I've encountered the OLE and Foxcode errors. I have ensured that the users' runtime is the correct version, and I tried placing a copy of the FoxCode table in the runtime folder.
>
>Does anyone have insight about the various causes of this?
>
>---Michael Reynolds
The first thing I'd change here is to get rid of the &. I will use
oExcel.ActiveWorkbook.SaveAs(forceext(m.lcFileName,'xls'))
If it's not broken, fix it until it is.
My Blog