Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel.Save() or SaveAs() fails with error 1426
Message
From
02/04/2008 09:09:15
James Beerbower
James Beerbower Enterprises
Hochheim Am Main, Germany
 
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01307589
Message ID:
01307595
Views:
17
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
Previous
Reply
Map
View

Click here to load this message in the networking platform