Article View: microsoft.public.office.developer.automation
Article #18Problem with Zoom and Windows count in Excel 2002
From: Roland Leisch
Date: Tue, 08 Mar 2005 09:46
Date: Tue, 08 Mar 2005 09:46
30 lines
2959 bytes
2959 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 (I can click on my entries but nothing happens). 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:
<1110272345.341662@news.liwest.at>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news.glorb.com!newsfeed.inode.at!newsfeeder1.noc.eunet-ag.at!news.eunet.at!paperboy.Austria.EU.net!not-for-mailReferences:
<1109601286.547140@news.liwest.at> <VA.000012c9.224fc27a@localhost.com> <1109661686.51153@news.liwest.at> <VA.000012d4.26bbf1a0@localhost.com> <1110013549.787152@news.liwest.at> <VA.0000131f.3c5f10cc@localhost.com>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!news3.google.com!news.glorb.com!newsfeed.inode.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 10:46:07 +0100 Organization: LiWest AG Lines: 30 Message-ID: <1110272345.341662@news.liwest.at> References: <1109601286.547140@news.liwest.at> <VA.000012c9.224fc27a@localhost.com> <1109661686.51153@news.liwest.at> <VA.000012d4.26bbf1a0@localhost.com> <1110013549.787152@news.liwest.at> <VA.0000131f.3c5f10cc@localhost.com> 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 1110275168 19321 212.33.32.148 (8 Mar 2005 09:46:08 GMT) X-Complaints-To: abuse@EUnet-AG.at NNTP-Posting-Date: Tue, 8 Mar 2005 09:46:08 +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 In-Reply-To: <VA.0000131f.3c5f10cc@localhost.com> Cache-Post-Path: news.liwest.at!unknown@cm192-173.liwest.at X-Cache: nntpcache 3.0.1 (see http://www.nntpcache.org/)