Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP 9 and Excel 2016 Automation Error
Message
From
20/03/2017 14:09:15
 
 
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows Server 2016
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01649203
Message ID:
01649205
Views:
87
>Hi,
>
>My application is using Excel automation (loExcel AS Excel.Application) to create an excel spreadsheet, they have gone thru several versions of excel with no problems but now the network admin installed Excel 2016 and my program is crashing at:
>
>loExcel.Save()
>
>"Unable to get the save property of the application class"
>
>Foxpro can't do automation with Excel 2016?
>
>Thank you in advance!

I may be completely wrong, but had a similar problem with IE automation which had worked for ages. The fix for IE was to always provide a value to the different events and method. IOW, try loExcel.Save(.T.)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform