Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Excel.Save() or SaveAs() fails with error 1426
Message
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Titre:
Excel.Save() or SaveAs() fails with error 1426
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Divers
Thread ID:
01307589
Message ID:
01307589
Vues:
153
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
Mathias Banda

Time is longer than a rope.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform