Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
A save file problem with automation (Excel)
Message
De
03/01/2007 08:09:35
 
 
À
03/01/2007 02:27:27
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Divers
Thread ID:
01181303
Message ID:
01181731
Vues:
9
>I just already try your support codes. I still get error “OLE Idispatch exception code 0 from Microsoft office Excel: Unable to get the Save property of Workbook class” at command sentence: "oExcel.ActiveWorkbook.SAVE"
>
>oExcel = createobject("excel.application")
>oExcel.Workbooks.OPEN(myExelfile)
>oExcel.DisplayAlerts = .F.

I have seen this error when Excel is trying to ask you whether you want to overwrite the existing file, but cannot do so because DisplayAlerts is set to False. I don't see why it would want to overwrite as you have opened the file yourself though?
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform