Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP 9 and Excel 2016 Automation Error
Message
From
22/03/2017 01:59:24
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:
01649241
Views:
91
>>>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()
>>
>
>
>Thank you Lutz, I'll give it a shot and report back.

In addition to Tore's post:

For SAVEAS I use two parameters
loExcel.ActiveWorkbook.SaveAs(DestFile,SaveAsFormat)
while SAVE runs without parameter.
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
Reply
Map
View

Click here to load this message in the networking platform