🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: microsoft.public.office.developer.automation
Article #19

Problem with Zoom and Windows count in Excel 2002

#19
From: Roland Leisch
Date: Tue, 08 Mar 2005 10:15
33 lines
2862 bytes
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!
Technical Details
Message-ID: <1110274115.825355@news.liwest.at>
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news.glorb.com!newsfeed.utanet.at!newsfeeder1.noc.eunet-ag.at!news.eunet.at!paperboy.Austria.EU.net!not-for-mail

Show Full Headers
Complete Article Headers
X-Google-Thread: fd4fc,e54bbe412343dd08
X-Google-Thread: f962e,e54bbe412343dd08
X-Google-Thread: fe15c,e54bbe412343dd08
X-Google-Thread: fd196,e54bbe412343dd08
X-Google-Attributes: gidfd4fc,gidf962e,gidfe15c,gidfd196,public
X-Google-Language: ENGLISH,ASCII-7-bit
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news.glorb.com!newsfeed.utanet.at!newsfeeder1.noc.eunet-ag.at!news.eunet.at!paperboy.Austria.EU.net!not-for-mail
From: Roland Leisch <leisch@24speed.at>
Newsgroups: microsoft.public.office.developer.automation,microsoft.public.vb.ole.automation,microsoft.public.win32.programmer.ole,borland.public.delphi.oleautomation
Subject: Problem with Zoom and Windows count in Excel 2002
Date: Tue, 08 Mar 2005 11:15:38 +0100
Organization: LiWest AG
Lines: 33
Message-ID: <1110274115.825355@news.liwest.at>
NNTP-Posting-Host: lilznntp.liwest.at
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Trace: paperboy.Austria.EU.net 1110276938 19975 212.33.32.148 (8 Mar 2005 10:15:38 GMT)
X-Complaints-To: abuse@EUnet-AG.at
NNTP-Posting-Date: Tue, 8 Mar 2005 10:15:38 +0000 (UTC)
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.5) Gecko/20041206 Thunderbird/1.0 Mnenhy/0.7.1
X-Accept-Language: en-us, en
Cache-Post-Path: news.liwest.at!unknown@cm192-173.liwest.at
X-Cache: nntpcache 3.0.1 (see http://www.nntpcache.org/)