LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.misc, microsoft.public.excel.programming,microsoft.public.excel, microsoft.public.excel.sdk
external usenet poster
 
Posts: 13
Default Exit from Excel edit mode using IDispatch

Thanks. That's one more way to find out if edit mode is on. The
question is still open: is there a way to turn it off?...

On Nov 14, 7:21 pm, "Andrei Smolin [Add-in Express]" <andrei dot
smolin @ add-in-express dot_com wrote:
Hello,

Excel provides the Application.Interactive property. Try (and catch) to set
it to false. If the exception fires, you cannot do anything because the edit
mode is on.

Regards from Belarus,

Andrei Smolin
Add-in Express Team Leaderwww.add-in-express.com

"Goofball" wrote in message

ups.com...

Thanks, however the problem is a bit different.


User opens some file and starts editing the cell, thus putting excel
into the edit mode. Then I launch my application that works with excel
ole object. And I can't activate that object, bacause of an error.
I've ivestigated that issue and found out, that this is because excel
is in the edit mode. So, I basically need to tell excel to exit that
mode. If its possible :)


On Nov 13, 10:34 pm, Colby Africa wrote:
It sounds like you need to call the following:


IOleInplaceObject::InPlaceDeactivate()
IOleObject::Close()
IUnknown::Realease()


In order to fully exit and close theExcelprocess. It has been years
since I did anything like that though!


HTH,


Colby




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I exit a cells edit mode? Adam Thwaites Excel Discussion (Misc queries) 6 November 13th 07 07:34 PM
run procedure when exit design mode Wim SKW Excel Discussion (Misc queries) 1 July 11th 07 09:24 AM
I can't exit from Design mode anymore Ray Excel Discussion (Misc queries) 0 April 20th 06 02:31 PM
What is procedure to exit formula auditing mode? W8 Excel Discussion (Misc queries) 3 February 14th 05 08:05 PM
Combo Box goes to edit mode even if design mode is in OFF position Chas Excel Discussion (Misc queries) 0 January 7th 05 07:21 PM


All times are GMT +1. The time now is 06:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"