Sometime i get "OLE error 800A03EC" when i call _VBProjects in delphi.

Add-in Express™ Support Service
That's what is more important than anything else

Sometime i get "OLE error 800A03EC" when i call _VBProjects in delphi.
 
tran van huy




Posts: 17
 Joined: 2009-02-02
:cry: Help me. I used codelines:
............
var vbPrjs:_VBProjects;
..............
vbPrjs:=_addin.ExcelApp.VBE.VBProjects;
//_addin:TAddinModule

but it appear message in exception

OLE error 800A03EC.
I use office 2007, delphi 7, add-in-express 2008
Ai bảo coder gàn dở, dòng code kia ai bảo chả c? hồn!?
Posted 02 Feb, 2009 23:22:29 Top
Andrei Smolin


Add-in Express team


Posts: 18849
 Joined: 2006-05-11
Hello Tran,

Isn't it Excel? Isn't a cell edited when you get this?

You can check this by setting ExcelApp.Interactive to false in a try/catch. If you catch an exception then sure, the user is editing a cell. Don't forget to restore the initial state of Interactive :)


Andrei Smolin
Add-in Express Team Leader
Posted 03 Feb, 2009 06:01:12 Top
tran van huy




Posts: 17
 Joined: 2009-02-02
Thnks Andrei Smolin. When I set Macro setting "Enable all macro := true" it work fine! So I was set registry to check it!
Ai bảo coder gàn dở, dòng code kia ai bảo chả c? hồn!?
Posted 03 Feb, 2009 22:54:20 Top