Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
A save file problem with automation (Excel)
Message
From
03/01/2007 08:09:35
 
 
To
03/01/2007 02:27:27
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
01181303
Message ID:
01181731
Views:
8
>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?
Previous
Reply
Map
View

Click here to load this message in the networking platform