Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel cell editing mode
I'm developing software which transfers data from serialport to Excel sheet.
The problem is software crashing while cursor is in cell and data is written to cell. In this project user MUST be able to modify/write cells sometimes. This is what I'm gettin: Call was rejected by callee exception from HRESULT 0x8001001(rpc_e_call_rejected). Is it possible to switch off cell editing mode while cursor is in cell ? I'm talking about similar effect with pressing enter while cursor is in cell. I'm using VB 2005 & Excel 2003. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel cell editing mode
Many people seem to attempt this, but to me your code should check if Excel
is in a suitable state to respond before you attempt to write to a cell, i.e. check if Excel is in Edit Mode. There was a suggestion from MS that you can check the Application.Ready property. However, it is not available on XL2000 and below. Also, some reply that it does not really work. Another suggestion was to see if the FileNew menu was enabled or not. It is a very bad idea to force the user out of Edit Mode, as they may have spent a long time entering a complex formula, only to lose everything because you want to put a value in a cell. NickHK "timo" wrote in message ... I'm developing software which transfers data from serialport to Excel sheet. The problem is software crashing while cursor is in cell and data is written to cell. In this project user MUST be able to modify/write cells sometimes. This is what I'm gettin: Call was rejected by callee exception from HRESULT 0x8001001(rpc_e_call_rejected). Is it possible to switch off cell editing mode while cursor is in cell ? I'm talking about similar effect with pressing enter while cursor is in cell. I'm using VB 2005 & Excel 2003. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel cell editing mode
In this case forcing user out of the Edit Mode would not be a big deal
because this software is made to very specific purpose only. Users of this one would typically write only short comments about values of got from serial port. Software only write in 2 columns, sample number and value of sample. I was thinking if it was possible to switch off Edit Mode, I would switch it off, do the transfer and switch it back to on. Off time would be very short it wouldn't be any problem. "NickHK" wrote: Many people seem to attempt this, but to me your code should check if Excel is in a suitable state to respond before you attempt to write to a cell, i.e. check if Excel is in Edit Mode. There was a suggestion from MS that you can check the Application.Ready property. However, it is not available on XL2000 and below. Also, some reply that it does not really work. Another suggestion was to see if the FileNew menu was enabled or not. It is a very bad idea to force the user out of Edit Mode, as they may have spent a long time entering a complex formula, only to lose everything because you want to put a value in a cell. NickHK "timo" wrote in message ... I'm developing software which transfers data from serialport to Excel sheet. The problem is software crashing while cursor is in cell and data is written to cell. In this project user MUST be able to modify/write cells sometimes. This is what I'm gettin: Call was rejected by callee exception from HRESULT 0x8001001(rpc_e_call_rejected). Is it possible to switch off cell editing mode while cursor is in cell ? I'm talking about similar effect with pressing enter while cursor is in cell. I'm using VB 2005 & Excel 2003. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel cell editing mode
There is Application.Interactive that may be suitable then. But I still say
you should only run your code when not in Edit Mode. NickHK "timo" wrote in message ... In this case forcing user out of the Edit Mode would not be a big deal because this software is made to very specific purpose only. Users of this one would typically write only short comments about values of got from serial port. Software only write in 2 columns, sample number and value of sample. I was thinking if it was possible to switch off Edit Mode, I would switch it off, do the transfer and switch it back to on. Off time would be very short it wouldn't be any problem. "NickHK" wrote: Many people seem to attempt this, but to me your code should check if Excel is in a suitable state to respond before you attempt to write to a cell, i.e. check if Excel is in Edit Mode. There was a suggestion from MS that you can check the Application.Ready property. However, it is not available on XL2000 and below. Also, some reply that it does not really work. Another suggestion was to see if the FileNew menu was enabled or not. It is a very bad idea to force the user out of Edit Mode, as they may have spent a long time entering a complex formula, only to lose everything because you want to put a value in a cell. NickHK "timo" wrote in message ... I'm developing software which transfers data from serialport to Excel sheet. The problem is software crashing while cursor is in cell and data is written to cell. In this project user MUST be able to modify/write cells sometimes. This is what I'm gettin: Call was rejected by callee exception from HRESULT 0x8001001(rpc_e_call_rejected). Is it possible to switch off cell editing mode while cursor is in cell ? I'm talking about similar effect with pressing enter while cursor is in cell. I'm using VB 2005 & Excel 2003. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel cell editing mode
Application.Interactive caused immediately some kind of error. Ready didn't
work either. Perhaps your way is the best. Only thing left to try is checking if the FileNew menu is enabled. How can I do it ? "NickHK" wrote: There is Application.Interactive that may be suitable then. But I still say you should only run your code when not in Edit Mode. NickHK "timo" wrote in message ... In this case forcing user out of the Edit Mode would not be a big deal because this software is made to very specific purpose only. Users of this one would typically write only short comments about values of got from serial port. Software only write in 2 columns, sample number and value of sample. I was thinking if it was possible to switch off Edit Mode, I would switch it off, do the transfer and switch it back to on. Off time would be very short it wouldn't be any problem. "NickHK" wrote: Many people seem to attempt this, but to me your code should check if Excel is in a suitable state to respond before you attempt to write to a cell, i.e. check if Excel is in Edit Mode. There was a suggestion from MS that you can check the Application.Ready property. However, it is not available on XL2000 and below. Also, some reply that it does not really work. Another suggestion was to see if the FileNew menu was enabled or not. It is a very bad idea to force the user out of Edit Mode, as they may have spent a long time entering a complex formula, only to lose everything because you want to put a value in a cell. NickHK "timo" wrote in message ... I'm developing software which transfers data from serialport to Excel sheet. The problem is software crashing while cursor is in cell and data is written to cell. In this project user MUST be able to modify/write cells sometimes. This is what I'm gettin: Call was rejected by callee exception from HRESULT 0x8001001(rpc_e_call_rejected). Is it possible to switch off cell editing mode while cursor is in cell ? I'm talking about similar effect with pressing enter while cursor is in cell. I'm using VB 2005 & Excel 2003. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel cell editing mode
You would probably get better help from one of NGs aim at Interop ;
microsoft.public.excel.sdk microsoft.public.excel.interopoledde NickHK "timo" ... Application.Interactive caused immediately some kind of error. Ready didn't work either. Perhaps your way is the best. Only thing left to try is checking if the FileNew menu is enabled. How can I do it ? "NickHK" wrote: There is Application.Interactive that may be suitable then. But I still say you should only run your code when not in Edit Mode. NickHK "timo" wrote in message ... In this case forcing user out of the Edit Mode would not be a big deal because this software is made to very specific purpose only. Users of this one would typically write only short comments about values of got from serial port. Software only write in 2 columns, sample number and value of sample. I was thinking if it was possible to switch off Edit Mode, I would switch it off, do the transfer and switch it back to on. Off time would be very short it wouldn't be any problem. "NickHK" wrote: Many people seem to attempt this, but to me your code should check if Excel is in a suitable state to respond before you attempt to write to a cell, i.e. check if Excel is in Edit Mode. There was a suggestion from MS that you can check the Application.Ready property. However, it is not available on XL2000 and below. Also, some reply that it does not really work. Another suggestion was to see if the FileNew menu was enabled or not. It is a very bad idea to force the user out of Edit Mode, as they may have spent a long time entering a complex formula, only to lose everything because you want to put a value in a cell. NickHK "timo" wrote in message ... I'm developing software which transfers data from serialport to Excel sheet. The problem is software crashing while cursor is in cell and data is written to cell. In this project user MUST be able to modify/write cells sometimes. This is what I'm gettin: Call was rejected by callee exception from HRESULT 0x8001001(rpc_e_call_rejected). Is it possible to switch off cell editing mode while cursor is in cell ? I'm talking about similar effect with pressing enter while cursor is in cell. I'm using VB 2005 & Excel 2003. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do you cancel editing mode in excel | Setting up and Configuration of Excel | |||
How do you stop excel from editing your cell? | New Users to Excel | |||
A Very stubborn apostrophe that only shows in editing mode and the formula bar... | Excel Discussion (Misc queries) | |||
VSTO and Excel--End Cell Edit Mode? | Excel Programming | |||
Excel always starts in Editing mode; i.e. buttons can be edited etc. | Excel Programming |