Article View: microsoft.public.office.developer.automation
Article #19Problem with Zoom and Windows count in Excel 2002
From: Roland Leisch
Date: Tue, 08 Mar 2005 10:15
Date: Tue, 08 Mar 2005 10:15
33 lines
2862 bytes
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-mailShow 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/)