How to cancel the Edit status

K

Kuoming

I use VC6 to write test data into excel file. The _Application, Workbooks,
_Workbook,Sheets and _Worksheet are initialized when program start, and test
result can be writen correctly.
But when user double click one Cell on active sheet, this Cell will be in
edit stauts, the GetRange function will cause program crash.

Range myrange;
myrange = workSheet.GetRange(COleVariant(strLine),COleVariant(strLine));

I try to use the SendKeys function to send "ESC", still couldn't change
foucs.
Kindly help how can I cancel the Edit status or How to disable the Edit
funtion.
 
T

Tom Ogilvy

I have never tried it, but before doing anything else,

Try Setting Application.Interactive to False


Make sure you turn it back on.
 
H

halimnurikhwan

Hi both,
Just try to guess ...
How about use :
on error goto blabla
or
on error resume next

I think that will ignore the error or skip the error but never
done the procedure well.

rgds,

Halim


Tom Ogilvy menuliskan:
 
N

NickHK

Others making add-in with .Net/Interop /C++ have this problem, because code
is trying to run whilst Excel is in edit mode.
At best, this means values are meaningless or worst (as you have found out)
a crash.

You should not be forcing users out of edit mode. If I am writing a long and
complex formula, then you cancel it all because your code wants to run, you
will not have many users.
You need you code to run at the correct time and not allow users to enter
edit mode until Excel/system is ready.

Here's one way to detect if excel is in edit mode
http://groups.google.co.uk/group/mi...da971212e22/197a5175d41417d3#197a5175d41417d3

NickHK
 
K

Kuoming

Thanks for great help!
Is there a way to force out of edit mode?
because user not really want to input data, only error operation let it into
edit mode.
If I set the Interactive to false, user couldn't read the data.
 
N

NickHK

How do you know that the "user not really want to input data" ?
If are including some mind-reading ability to Excel, that may be an option,
otherwise don't do it.
If edit mode is a result of your bad code, then fix the code.

But with all this you may be better off in a NG that deals with this; those
for .Net/Interop and/or microsoft.public.excel.sdk

NickHK
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top