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:07:37
Lutz Scheffler
Lutz Scheffler Software Ingenieurbüro
Dresden, Germany
 
 
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:
01649204
Views:
224
>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!

Try
loExcel.ActiveWorkbook.SaveAs()
loExcel.ActiveWorkbook.SAVE()
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord

Weeks of programming can save you hours of planning.

Off

There is no place like [::1]
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform