Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Excel problem after installing Office 2010??
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Divers
Thread ID:
01554079
Message ID:
01554099
Vues:
55
aerror shows this:

1429
OLE iDispatch exception code 0 from Microsoft Excel: Unable to to get the Save property of the Workbook class.
Unable to get the Save property of the Workbook class
Microsoft Excel
x1main11.chm
0
1004


>Ahh.. I misread the original post. Are you getting a specific error or is it a general COM error? (Did you use AERROR?)
>
>If you try the same steps within Excel, do you get a dialog or error message?
>
>What version were you using before 2010?
>
>>Yes.
>>
>>>Did you install the 32 bit version of Office?
>>>
>>>>This was working for me until I installed Office 2010...
>>>>
>>>>tlcExcelFileName = GETFILE('xls')
>>>>oExcelObject = CREATEOBJECT('Excel.Application')
>>>>oExcelWorkbook = oExcelObject.Application.Workbooks.Open(tlcExcelFileName)
>>>>oExcelWorkbook.ActiveSheet.UsedRange.EntireColumn.AutoFit()
>>>>oExcelWorkbook.Save
>>>>oExcelObject.Quit()
>>>>oExcelObject = NULL
>>>>
>>>>
>>>>...now it's giving me an error when it gets to the oExcelWorkbook.save() line.
>>>>
>>>>Any ideas?
>>>>
>>>>Thanks!
ICQ 10556 (ya), 254117
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform