Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
VFP 9 and Excel 2016 Automation Error
Message
De
22/03/2017 01:59:24
Lutz Scheffler
Lutz Scheffler Software Ingenieurbüro
Dresden, Allemagne
 
 
À
21/03/2017 12:40:41
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows Server 2016
Database:
MS SQL Server
Application:
Desktop
Divers
Thread ID:
01649203
Message ID:
01649241
Vues:
92
>>>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]
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform