Ole 800A03EC error when using TExcelWorkBook SaveAs method in Delphi 7?

I have seen this error once when automating Excel. It happened when the user had a cell in editmode and you tried to automate that instance. Excel doesn't like it when you are editing a cell and some program is fiddling around in the background.

I have seen this error once when automating Excel. It happened when the user had a cell in editmode and you tried to automate that instance. Excel doesn't like it when you are editing a cell and some program is fiddling around in the background.So this is what's happening at your client (I think): Your client has Excel open and is editing a cell (select a cell and press F2) Your code starts: You create a TExcelApplication and accesses the Workbooks property.

Since your Excel application is not yet connected it calls TOleServer. Connect (look at the implementation of GetDefaultInterface) Since the default connectkind is ckRunningOrNew, TExcelApplication connects to the running instance. Because the client is editing a cell you get an error on the Open method.

How you can prevent this: Set ConnectKind of your TExcelApplication to ckNewInstance so you'll always work in a separate Excel instance.

Thanks, will try this – Tofig Hasanov Mar 3 '10 at 12:16.

OLE 800A03EC usually has to do with invalid characters in your Excel file. Are you using the same data as your client? Is there a difference in Regional Settings?Etc.

Etc. There could be number of errors for this, but most likely (as a quick google told me) it is a regional setting.

The regional settings are probably different. The file we use is the same. I need the program to run smoothly on any reginal settings though, so what should I do?

– Tofig Hasanov Mar 3 '10 at 12:17.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.