Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Excel.Save() or SaveAs() fails with error 1426
Message
De
02/04/2008 09:09:15
James Beerbower
James Beerbower Enterprises
Hochheim Am Main, Allemagne
 
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Divers
Thread ID:
01307589
Message ID:
01307595
Vues:
18
Hi,

It seems 1426 is class not found. Perhaps the two customers have a problem with their excel installation?

Jamie

>Hi All,
>
>I have 2 customers out of 1000's who for some reason Excel is failing to save files.
>
>I did run a test on one of the sites with this code:
>
>Local oExcel, oWorkbook, oWorksheet
>oExcel = CreateObject("Excel.Application")
>oWorkbook = oExcel.Workbooks.Add()
>oWorksheet = oWorkbook.Worksheets(1)
>oExcel.DisplayAlerts = .F.
>oExcel.Cells(1, 1).Value = "AAA"
>oExcel.Cells(1, 2).Value = "BBB"
>oExcel.Cells(1, 3).Value = "CCC"
>oExcel.Cells(1, 4).Value = "DDD"
>
>oWorkbook.SaveAs("C:\Test.xls") &&- errors here
>oExcel.Quit()
>Return
>
>
>Any ideas please?
>
>Thank you
James Beerbower
James Beerbower Enterprises
Frankfurt, Deutschland
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform