Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel SaveAs OLE Error
Message
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01531479
Message ID:
01531484
Views:
70
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform