Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
simple excel problem....
how to find out whether the active cell is in edit mode or not?
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Simple problem, simple formula, no FUNCTION ! | Excel Worksheet Functions | |||
Simple Excel VB problem | Excel Discussion (Misc queries) | |||
Mail Merging Dates from Excel - Word Simple Problem! | Excel Discussion (Misc queries) | |||
Problem with Excel: Simple multiplying calculations don't work. | Excel Discussion (Misc queries) | |||
i've got a simple excel problem that needs solving... | Excel Discussion (Misc queries) |