Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
vj5 vj5 is offline
external usenet poster
 
Posts: 22
Default simple excel problem....

how to find out whether the active cell is in edit mode or not?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,391
Default simple excel problem....

As we have said many time, code does not run in edit mode.
I suppose you could look at the cell.

NickHK

"vj5" wrote in message
...
how to find out whether the active cell is in edit mode or not?



  #3   Report Post  
Posted to microsoft.public.excel.programming
vj5 vj5 is offline
external usenet poster
 
Posts: 22
Default simple excel problem....

thanks for reply
but my code is working when the cell in edit mode
i wants to know how we can find that cell is in edit mode or normal mode?

"NickHK" wrote:

As we have said many time, code does not run in edit mode.
I suppose you could look at the cell.

NickHK

"vj5" wrote in message
...
how to find out whether the active cell is in edit mode or not?




  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,391
Default simple excel problem....

Show the code that is running in edit mode.

NickHK

"vj5" wrote in message
...
thanks for reply
but my code is working when the cell in edit mode
i wants to know how we can find that cell is in edit mode or normal mode?

"NickHK" wrote:

As we have said many time, code does not run in edit mode.
I suppose you could look at the cell.

NickHK

"vj5" wrote in message
...
how to find out whether the active cell is in edit mode or not?






  #5   Report Post  
Posted to microsoft.public.excel.programming
vj5 vj5 is offline
external usenet poster
 
Posts: 22
Default simple excel problem....

on a button click its runnning:
icrosoft.Office.Interop.Excel._Application appEXL =
(Microsoft.Office.Interop.Excel._Application)appli cationObject;
//.GetType().InvokeMember("Application", BindingFlags.GetProperty, null,
applicationObject, null);
Microsoft.Office.Interop.Excel._Worksheet wkSheet =
(Microsoft.Office.Interop.Excel._Worksheet)appEXL. ActiveWorkbook.ActiveSheet;
..................
during debugging i am findnig l the values like:
?appEXL.ActiveWindow will return :

{System.__ComObject}
[System.__ComObject]: {System.__ComObject}
_DisplayRightToLeft: false
ActiveCell: {System.__ComObject}
ActiveChart: null
ActivePane: {System.__ComObject}
ActiveSheet: {System.__ComObject}
Application: {System.__ComObject}
Caption: "Book1"
Creator: xlCreatorCode
DisplayFormulas: false
DisplayGridlines: true
DisplayHeadings: true
DisplayHorizontalScrollBar: true
DisplayOutline: true
DisplayRightToLeft: false
DisplayVerticalScrollBar: true
DisplayWorkbookTabs: true
DisplayZeros: true
EnableResize: 'appEXL.ActiveWindow.EnableResize' threw an exception of
type 'System.Runtime.InteropServices.COMException'
FreezePanes: false
GridlineColor: 0
GridlineColorIndex: xlColorIndexAutomatic
Height: 177.75
Index: 1
Left: -2.75
OnWindow: 'appEXL.ActiveWindow.OnWindow' threw an exception of type
'System.Runtime.InteropServices.COMException'
Panes: {System.__ComObject}
Parent: {Microsoft.Office.Interop.Excel.WorkbookClass}
RangeSelection: {System.__ComObject}
ScrollColumn: 1
ScrollRow: 1
SelectedSheets: {System.__ComObject}
Selection: {System.__ComObject}
Split: false
SplitColumn: 0
SplitHorizontal: 0.0
SplitRow: 0
SplitVertical: 0.0
TabRatio: 0.6
Top: -22.25
Type: xlWorkbook
UsableHeight: 138.75
UsableWidth: 537.0
View: xlNormalView
Visible: true
VisibleRange: {System.__ComObject}
Width: 556.5
WindowNumber: 1
WindowState: xlMaximized
Zoom: 100.0
but unable to find out whether the cell is in edit mode or not?


"NickHK" wrote:

Show the code that is running in edit mode.

NickHK

"vj5" wrote in message
...
thanks for reply
but my code is working when the cell in edit mode
i wants to know how we can find that cell is in edit mode or normal mode?

"NickHK" wrote:

As we have said many time, code does not run in edit mode.
I suppose you could look at the cell.

NickHK

"vj5" wrote in message
...
how to find out whether the active cell is in edit mode or not?








  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,391
Default simple excel problem....

I don't use .Net/Interop but I do not see any Excel code running <<whilst in
Edit Mode.
If you are talking about multi-threading and your .Net code, that's nothing
to do with Excel
But your code automating Excel will mean the user cannot enter edit mode
until that code has finished.

If you can run any automation code, then you are not in edit mode.
I don't if DDE channels still respond in edit mode, but as using the .Net
Framework, there's no support for DDE AFAIK.

NickHK


"vj5" wrote in message
...
on a button click its runnning:
icrosoft.Office.Interop.Excel._Application appEXL =
(Microsoft.Office.Interop.Excel._Application)appli cationObject;
//.GetType().InvokeMember("Application", BindingFlags.GetProperty, null,
applicationObject, null);
Microsoft.Office.Interop.Excel._Worksheet wkSheet =

(Microsoft.Office.Interop.Excel._Worksheet)appEXL. ActiveWorkbook.ActiveSheet
;
..................
during debugging i am findnig l the values like:
?appEXL.ActiveWindow will return :

{System.__ComObject}
[System.__ComObject]: {System.__ComObject}
_DisplayRightToLeft: false
ActiveCell: {System.__ComObject}
ActiveChart: null
ActivePane: {System.__ComObject}
ActiveSheet: {System.__ComObject}
Application: {System.__ComObject}
Caption: "Book1"
Creator: xlCreatorCode
DisplayFormulas: false
DisplayGridlines: true
DisplayHeadings: true
DisplayHorizontalScrollBar: true
DisplayOutline: true
DisplayRightToLeft: false
DisplayVerticalScrollBar: true
DisplayWorkbookTabs: true
DisplayZeros: true
EnableResize: 'appEXL.ActiveWindow.EnableResize' threw an exception of
type 'System.Runtime.InteropServices.COMException'
FreezePanes: false
GridlineColor: 0
GridlineColorIndex: xlColorIndexAutomatic
Height: 177.75
Index: 1
Left: -2.75
OnWindow: 'appEXL.ActiveWindow.OnWindow' threw an exception of type
'System.Runtime.InteropServices.COMException'
Panes: {System.__ComObject}
Parent: {Microsoft.Office.Interop.Excel.WorkbookClass}
RangeSelection: {System.__ComObject}
ScrollColumn: 1
ScrollRow: 1
SelectedSheets: {System.__ComObject}
Selection: {System.__ComObject}
Split: false
SplitColumn: 0
SplitHorizontal: 0.0
SplitRow: 0
SplitVertical: 0.0
TabRatio: 0.6
Top: -22.25
Type: xlWorkbook
UsableHeight: 138.75
UsableWidth: 537.0
View: xlNormalView
Visible: true
VisibleRange: {System.__ComObject}
Width: 556.5
WindowNumber: 1
WindowState: xlMaximized
Zoom: 100.0
but unable to find out whether the cell is in edit mode or not?


"NickHK" wrote:

Show the code that is running in edit mode.

NickHK

"vj5" wrote in message
...
thanks for reply
but my code is working when the cell in edit mode
i wants to know how we can find that cell is in edit mode or normal

mode?

"NickHK" wrote:

As we have said many time, code does not run in edit mode.
I suppose you could look at the cell.

NickHK

"vj5" wrote in message
...
how to find out whether the active cell is in edit mode or not?








  #7   Report Post  
Posted to microsoft.public.excel.programming
vj5 vj5 is offline
external usenet poster
 
Posts: 22
Default simple excel problem....

i am in edit mode , i clicked a commandbarbutton in edit mode and it runs
the code.
its working fine but my problem is to find out whether the cell is in edit
mode or not( as my code is working in both cases)?
is there any way?

"NickHK" wrote:

I don't use .Net/Interop but I do not see any Excel code running <<whilst in
Edit Mode.
If you are talking about multi-threading and your .Net code, that's nothing
to do with Excel
But your code automating Excel will mean the user cannot enter edit mode
until that code has finished.

If you can run any automation code, then you are not in edit mode.
I don't if DDE channels still respond in edit mode, but as using the .Net
Framework, there's no support for DDE AFAIK.

NickHK


"vj5" wrote in message
...
on a button click its runnning:
icrosoft.Office.Interop.Excel._Application appEXL =
(Microsoft.Office.Interop.Excel._Application)appli cationObject;
//.GetType().InvokeMember("Application", BindingFlags.GetProperty, null,
applicationObject, null);
Microsoft.Office.Interop.Excel._Worksheet wkSheet =

(Microsoft.Office.Interop.Excel._Worksheet)appEXL. ActiveWorkbook.ActiveSheet
;
..................
during debugging i am findnig l the values like:
?appEXL.ActiveWindow will return :

{System.__ComObject}
[System.__ComObject]: {System.__ComObject}
_DisplayRightToLeft: false
ActiveCell: {System.__ComObject}
ActiveChart: null
ActivePane: {System.__ComObject}
ActiveSheet: {System.__ComObject}
Application: {System.__ComObject}
Caption: "Book1"
Creator: xlCreatorCode
DisplayFormulas: false
DisplayGridlines: true
DisplayHeadings: true
DisplayHorizontalScrollBar: true
DisplayOutline: true
DisplayRightToLeft: false
DisplayVerticalScrollBar: true
DisplayWorkbookTabs: true
DisplayZeros: true
EnableResize: 'appEXL.ActiveWindow.EnableResize' threw an exception of
type 'System.Runtime.InteropServices.COMException'
FreezePanes: false
GridlineColor: 0
GridlineColorIndex: xlColorIndexAutomatic
Height: 177.75
Index: 1
Left: -2.75
OnWindow: 'appEXL.ActiveWindow.OnWindow' threw an exception of type
'System.Runtime.InteropServices.COMException'
Panes: {System.__ComObject}
Parent: {Microsoft.Office.Interop.Excel.WorkbookClass}
RangeSelection: {System.__ComObject}
ScrollColumn: 1
ScrollRow: 1
SelectedSheets: {System.__ComObject}
Selection: {System.__ComObject}
Split: false
SplitColumn: 0
SplitHorizontal: 0.0
SplitRow: 0
SplitVertical: 0.0
TabRatio: 0.6
Top: -22.25
Type: xlWorkbook
UsableHeight: 138.75
UsableWidth: 537.0
View: xlNormalView
Visible: true
VisibleRange: {System.__ComObject}
Width: 556.5
WindowNumber: 1
WindowState: xlMaximized
Zoom: 100.0
but unable to find out whether the cell is in edit mode or not?


"NickHK" wrote:

Show the code that is running in edit mode.

NickHK

"vj5" wrote in message
...
thanks for reply
but my code is working when the cell in edit mode
i wants to know how we can find that cell is in edit mode or normal

mode?

"NickHK" wrote:

As we have said many time, code does not run in edit mode.
I suppose you could look at the cell.

NickHK

"vj5" wrote in message
...
how to find out whether the active cell is in edit mode or not?









  #8   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,391
Default simple excel problem....

According to
http://forums.microsoft.com/MSDN/Sho...58493&SiteID=1
one option, if on Excel XP or higher is to check Application.Ready.

Or
http://groups.google.co.uk/group/mic...7a5175d41417d3

NickHK

"vj5" wrote in message
...
i am in edit mode , i clicked a commandbarbutton in edit mode and it runs
the code.
its working fine but my problem is to find out whether the cell is in

edit
mode or not( as my code is working in both cases)?
is there any way?

"NickHK" wrote:

I don't use .Net/Interop but I do not see any Excel code running

<<whilst in
Edit Mode.
If you are talking about multi-threading and your .Net code, that's

nothing
to do with Excel
But your code automating Excel will mean the user cannot enter edit mode
until that code has finished.

If you can run any automation code, then you are not in edit mode.
I don't if DDE channels still respond in edit mode, but as using the

..Net
Framework, there's no support for DDE AFAIK.

NickHK


"vj5" wrote in message
...
on a button click its runnning:
icrosoft.Office.Interop.Excel._Application appEXL =
(Microsoft.Office.Interop.Excel._Application)appli cationObject;
//.GetType().InvokeMember("Application", BindingFlags.GetProperty,

null,
applicationObject, null);
Microsoft.Office.Interop.Excel._Worksheet wkSheet =


(Microsoft.Office.Interop.Excel._Worksheet)appEXL. ActiveWorkbook.ActiveSheet
;
..................
during debugging i am findnig l the values like:
?appEXL.ActiveWindow will return :

{System.__ComObject}
[System.__ComObject]: {System.__ComObject}
_DisplayRightToLeft: false
ActiveCell: {System.__ComObject}
ActiveChart: null
ActivePane: {System.__ComObject}
ActiveSheet: {System.__ComObject}
Application: {System.__ComObject}
Caption: "Book1"
Creator: xlCreatorCode
DisplayFormulas: false
DisplayGridlines: true
DisplayHeadings: true
DisplayHorizontalScrollBar: true
DisplayOutline: true
DisplayRightToLeft: false
DisplayVerticalScrollBar: true
DisplayWorkbookTabs: true
DisplayZeros: true
EnableResize: 'appEXL.ActiveWindow.EnableResize' threw an

exception of
type 'System.Runtime.InteropServices.COMException'
FreezePanes: false
GridlineColor: 0
GridlineColorIndex: xlColorIndexAutomatic
Height: 177.75
Index: 1
Left: -2.75
OnWindow: 'appEXL.ActiveWindow.OnWindow' threw an exception of

type
'System.Runtime.InteropServices.COMException'
Panes: {System.__ComObject}
Parent: {Microsoft.Office.Interop.Excel.WorkbookClass}
RangeSelection: {System.__ComObject}
ScrollColumn: 1
ScrollRow: 1
SelectedSheets: {System.__ComObject}
Selection: {System.__ComObject}
Split: false
SplitColumn: 0
SplitHorizontal: 0.0
SplitRow: 0
SplitVertical: 0.0
TabRatio: 0.6
Top: -22.25
Type: xlWorkbook
UsableHeight: 138.75
UsableWidth: 537.0
View: xlNormalView
Visible: true
VisibleRange: {System.__ComObject}
Width: 556.5
WindowNumber: 1
WindowState: xlMaximized
Zoom: 100.0
but unable to find out whether the cell is in edit mode or not?


"NickHK" wrote:

Show the code that is running in edit mode.

NickHK

"vj5" wrote in message
...
thanks for reply
but my code is working when the cell in edit mode
i wants to know how we can find that cell is in edit mode or

normal
mode?

"NickHK" wrote:

As we have said many time, code does not run in edit mode.
I suppose you could look at the cell.

NickHK

"vj5" wrote in message
...
how to find out whether the active cell is in edit mode or

not?











  #9   Report Post  
Posted to microsoft.public.excel.programming
vj5 vj5 is offline
external usenet poster
 
Posts: 22
Default simple excel problem....

thanks again for helping!
application.ready always returns True in both cases
(cell in edit mode or not in edit mode)


"NickHK" wrote:

According to
http://forums.microsoft.com/MSDN/Sho...58493&SiteID=1
one option, if on Excel XP or higher is to check Application.Ready.

Or
http://groups.google.co.uk/group/mic...7a5175d41417d3

NickHK

"vj5" wrote in message
...
i am in edit mode , i clicked a commandbarbutton in edit mode and it runs
the code.
its working fine but my problem is to find out whether the cell is in

edit
mode or not( as my code is working in both cases)?
is there any way?

"NickHK" wrote:

I don't use .Net/Interop but I do not see any Excel code running

<<whilst in
Edit Mode.
If you are talking about multi-threading and your .Net code, that's

nothing
to do with Excel
But your code automating Excel will mean the user cannot enter edit mode
until that code has finished.

If you can run any automation code, then you are not in edit mode.
I don't if DDE channels still respond in edit mode, but as using the

..Net
Framework, there's no support for DDE AFAIK.

NickHK


"vj5" wrote in message
...
on a button click its runnning:
icrosoft.Office.Interop.Excel._Application appEXL =
(Microsoft.Office.Interop.Excel._Application)appli cationObject;
//.GetType().InvokeMember("Application", BindingFlags.GetProperty,

null,
applicationObject, null);
Microsoft.Office.Interop.Excel._Worksheet wkSheet =


(Microsoft.Office.Interop.Excel._Worksheet)appEXL. ActiveWorkbook.ActiveSheet
;
..................
during debugging i am findnig l the values like:
?appEXL.ActiveWindow will return :

{System.__ComObject}
[System.__ComObject]: {System.__ComObject}
_DisplayRightToLeft: false
ActiveCell: {System.__ComObject}
ActiveChart: null
ActivePane: {System.__ComObject}
ActiveSheet: {System.__ComObject}
Application: {System.__ComObject}
Caption: "Book1"
Creator: xlCreatorCode
DisplayFormulas: false
DisplayGridlines: true
DisplayHeadings: true
DisplayHorizontalScrollBar: true
DisplayOutline: true
DisplayRightToLeft: false
DisplayVerticalScrollBar: true
DisplayWorkbookTabs: true
DisplayZeros: true
EnableResize: 'appEXL.ActiveWindow.EnableResize' threw an

exception of
type 'System.Runtime.InteropServices.COMException'
FreezePanes: false
GridlineColor: 0
GridlineColorIndex: xlColorIndexAutomatic
Height: 177.75
Index: 1
Left: -2.75
OnWindow: 'appEXL.ActiveWindow.OnWindow' threw an exception of

type
'System.Runtime.InteropServices.COMException'
Panes: {System.__ComObject}
Parent: {Microsoft.Office.Interop.Excel.WorkbookClass}
RangeSelection: {System.__ComObject}
ScrollColumn: 1
ScrollRow: 1
SelectedSheets: {System.__ComObject}
Selection: {System.__ComObject}
Split: false
SplitColumn: 0
SplitHorizontal: 0.0
SplitRow: 0
SplitVertical: 0.0
TabRatio: 0.6
Top: -22.25
Type: xlWorkbook
UsableHeight: 138.75
UsableWidth: 537.0
View: xlNormalView
Visible: true
VisibleRange: {System.__ComObject}
Width: 556.5
WindowNumber: 1
WindowState: xlMaximized
Zoom: 100.0
but unable to find out whether the cell is in edit mode or not?


"NickHK" wrote:

Show the code that is running in edit mode.

NickHK

"vj5" wrote in message
...
thanks for reply
but my code is working when the cell in edit mode
i wants to know how we can find that cell is in edit mode or

normal
mode?

"NickHK" wrote:

As we have said many time, code does not run in edit mode.
I suppose you could look at the cell.

NickHK

"vj5" wrote in message
...
how to find out whether the active cell is in edit mode or

not?












  #10   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 415
Default simple excel problem....

I was surprised that it even exists.
Logically, if the application is not ready, how can answer that question ???

What about the other method ?

NickHK

"vj5" ...
thanks again for helping!
application.ready always returns True in both cases
(cell in edit mode or not in edit mode)


"NickHK" wrote:

According to
http://forums.microsoft.com/MSDN/Sho...58493&SiteID=1
one option, if on Excel XP or higher is to check Application.Ready.

Or
http://groups.google.co.uk/group/mic...7a5175d41417d3

NickHK

"vj5" wrote in message
...
i am in edit mode , i clicked a commandbarbutton in edit mode and it
runs
the code.
its working fine but my problem is to find out whether the cell is in

edit
mode or not( as my code is working in both cases)?
is there any way?

"NickHK" wrote:

I don't use .Net/Interop but I do not see any Excel code running

<<whilst in
Edit Mode.
If you are talking about multi-threading and your .Net code, that's

nothing
to do with Excel
But your code automating Excel will mean the user cannot enter edit
mode
until that code has finished.

If you can run any automation code, then you are not in edit mode.
I don't if DDE channels still respond in edit mode, but as using the

..Net
Framework, there's no support for DDE AFAIK.

NickHK


"vj5" wrote in message
...
on a button click its runnning:
icrosoft.Office.Interop.Excel._Application appEXL =
(Microsoft.Office.Interop.Excel._Application)appli cationObject;
//.GetType().InvokeMember("Application", BindingFlags.GetProperty,

null,
applicationObject, null);
Microsoft.Office.Interop.Excel._Worksheet wkSheet =


(Microsoft.Office.Interop.Excel._Worksheet)appEXL. ActiveWorkbook.ActiveSheet
;
..................
during debugging i am findnig l the values like:
?appEXL.ActiveWindow will return :

{System.__ComObject}
[System.__ComObject]: {System.__ComObject}
_DisplayRightToLeft: false
ActiveCell: {System.__ComObject}
ActiveChart: null
ActivePane: {System.__ComObject}
ActiveSheet: {System.__ComObject}
Application: {System.__ComObject}
Caption: "Book1"
Creator: xlCreatorCode
DisplayFormulas: false
DisplayGridlines: true
DisplayHeadings: true
DisplayHorizontalScrollBar: true
DisplayOutline: true
DisplayRightToLeft: false
DisplayVerticalScrollBar: true
DisplayWorkbookTabs: true
DisplayZeros: true
EnableResize: 'appEXL.ActiveWindow.EnableResize' threw an

exception of
type 'System.Runtime.InteropServices.COMException'
FreezePanes: false
GridlineColor: 0
GridlineColorIndex: xlColorIndexAutomatic
Height: 177.75
Index: 1
Left: -2.75
OnWindow: 'appEXL.ActiveWindow.OnWindow' threw an exception of

type
'System.Runtime.InteropServices.COMException'
Panes: {System.__ComObject}
Parent: {Microsoft.Office.Interop.Excel.WorkbookClass}
RangeSelection: {System.__ComObject}
ScrollColumn: 1
ScrollRow: 1
SelectedSheets: {System.__ComObject}
Selection: {System.__ComObject}
Split: false
SplitColumn: 0
SplitHorizontal: 0.0
SplitRow: 0
SplitVertical: 0.0
TabRatio: 0.6
Top: -22.25
Type: xlWorkbook
UsableHeight: 138.75
UsableWidth: 537.0
View: xlNormalView
Visible: true
VisibleRange: {System.__ComObject}
Width: 556.5
WindowNumber: 1
WindowState: xlMaximized
Zoom: 100.0
but unable to find out whether the cell is in edit mode or not?


"NickHK" wrote:

Show the code that is running in edit mode.

NickHK

"vj5" wrote in message
...
thanks for reply
but my code is working when the cell in edit mode
i wants to know how we can find that cell is in edit mode or

normal
mode?

"NickHK" wrote:

As we have said many time, code does not run in edit mode.
I suppose you could look at the cell.

NickHK

"vj5" wrote in message
...
how to find out whether the active cell is in edit mode or

not?














Reply
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
Simple problem, simple formula, no FUNCTION ! Ron@Buy Excel Worksheet Functions 6 September 28th 07 04:51 PM
Simple Excel VB problem [email protected] Excel Discussion (Misc queries) 3 March 28th 07 01:50 AM
Mail Merging Dates from Excel - Word Simple Problem! CFD Excel Discussion (Misc queries) 1 July 13th 06 01:08 AM
Problem with Excel: Simple multiplying calculations don't work. dforty3 Excel Discussion (Misc queries) 3 July 22nd 05 05:47 PM
i've got a simple excel problem that needs solving... Massive Excel Discussion (Misc queries) 6 May 16th 05 08:46 AM


All times are GMT +1. The time now is 05:50 PM.

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

About Us

"It's about Microsoft Excel"