LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default VSTO and Excel-- End Cell Edit Mode Programmatically?

Because of processing large data set, I used a second thread to fill
the data into the cells by asynchronous invoke. So that, the interface
can keep active, while filling the grids. Once user selected a cell and
entered into the edit mode, the problem came out. The program can't
access the Sheet object, can't visit the Range property. if tried, a
COMException is the result. So How can I end cell edit mode
programmatically?

I found a way to end cell edit mode in this forum, that is using
"SendKeys" method. But even calling this function will generate an
exception. How do I solve this problem? Or should I stop interface
responding when filling large data set?

Thanks,

 
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
Excel 2007-starts in cell edit mode dalec Excel Discussion (Misc queries) 0 August 1st 07 11:14 PM
Is it possible to arrow to a different cell while in edit mode? Latka2k Excel Discussion (Misc queries) 1 December 9th 05 09:51 PM
VSTO and Excel--End Cell Edit Mode? Jim Tilson Excel Programming 15 September 29th 05 08:40 PM
Invoke €śQuery Wizard€ť programmatically from automation or VSTO [email protected] Excel Programming 3 November 5th 04 11:28 AM
Invoke €śQuery Wizard€ť programmatically from automation or VSTO [email protected] Excel Programming 0 October 15th 04 12:09 AM


All times are GMT +1. The time now is 09:22 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"