R
Roland Leisch
Hello!
I have posted the problem before but there were some misunderstanding so
I will post again:
I have an application which uses an ole container to display an excel
workbook. In my application I have a menubar in which I can change Zoom
settings for the contained workbook (since I prohibited any interaction
on the workbook itself as I want it only to be displayed and not be
changed in any way).
If I start my application I can change the zoom settings without any
problems.
But if a start my application a second time (with an other workbook) Im
not able to change any settings in the first workbook instead I get the
following error: COM object method returns error code: 0x80020009;
DISP_E_EXCEPTION where I want to set the new Zoomfactor ( I found out,
that Windows.Count is zero and I assume that this is the cause of the
problem).
So I tried to implement a workaround: I add custom document properties
which allow me to identify the open workbooks. I iterate all workbooks
and if I find the right workbook I call workbook.activate(lcid).
The very strange thing is that this works only if one instance of my
application is open - if a second instance is running I get: COM object
method returns error code: 0x800A03EC and only the last started instance
reacts - the first instance gives me the 0x800A03EC error.
Has anybody here got an idea where the problem could be?
Thanks in advance!
I have posted the problem before but there were some misunderstanding so
I will post again:
I have an application which uses an ole container to display an excel
workbook. In my application I have a menubar in which I can change Zoom
settings for the contained workbook (since I prohibited any interaction
on the workbook itself as I want it only to be displayed and not be
changed in any way).
If I start my application I can change the zoom settings without any
problems.
But if a start my application a second time (with an other workbook) Im
not able to change any settings in the first workbook instead I get the
following error: COM object method returns error code: 0x80020009;
DISP_E_EXCEPTION where I want to set the new Zoomfactor ( I found out,
that Windows.Count is zero and I assume that this is the cause of the
problem).
So I tried to implement a workaround: I add custom document properties
which allow me to identify the open workbooks. I iterate all workbooks
and if I find the right workbook I call workbook.activate(lcid).
The very strange thing is that this works only if one instance of my
application is open - if a second instance is running I get: COM object
method returns error code: 0x800A03EC and only the last started instance
reacts - the first instance gives me the 0x800A03EC error.
Has anybody here got an idea where the problem could be?
Thanks in advance!