Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Map of controls-numbers
I know that each control (menu option) has a number assign to it.
Where from can I get this map? Thanks, Mircea |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Map of controls-numbers
Mircea,
Here is a starter for you http://support.microsoft.com/default.aspx?kbid=159466 XL97: List of ID Numbers for Built-In Command Bar Controls http://support.microsoft.com/default.aspx?kbid=213552 XL2000: List of ID Numbers for Built-In CommandBar Controls http://support.microsoft.com/default.aspx?kbid=162814 XL97: Sample Macros to Return ID for a CommandBar Control http://support.microsoft.com/default.aspx?kbid=213211 XL2000: Sample Macros to Return ID for a CommandBar Control -- HTH RP (remove nothere from the email address if mailing direct) "Mircea Pleteriu" wrote in message ... I know that each control (menu option) has a number assign to it. Where from can I get this map? Thanks, Mircea |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Map of controls-numbers
Thanks a lot Bob!
"Bob Phillips" wrote in message ... Mircea, Here is a starter for you http://support.microsoft.com/default.aspx?kbid=159466 XL97: List of ID Numbers for Built-In Command Bar Controls http://support.microsoft.com/default.aspx?kbid=213552 XL2000: List of ID Numbers for Built-In CommandBar Controls http://support.microsoft.com/default.aspx?kbid=162814 XL97: Sample Macros to Return ID for a CommandBar Control http://support.microsoft.com/default.aspx?kbid=213211 XL2000: Sample Macros to Return ID for a CommandBar Control -- HTH RP (remove nothere from the email address if mailing direct) "Mircea Pleteriu" wrote in message ... I know that each control (menu option) has a number assign to it. Where from can I get this map? Thanks, Mircea |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Map of controls-numbers
Is there no list of ID numbers for Excel 2002(3) ?!?
"Bob Phillips" wrote in message ... Mircea, Here is a starter for you http://support.microsoft.com/default.aspx?kbid=159466 XL97: List of ID Numbers for Built-In Command Bar Controls http://support.microsoft.com/default.aspx?kbid=213552 XL2000: List of ID Numbers for Built-In CommandBar Controls http://support.microsoft.com/default.aspx?kbid=162814 XL97: Sample Macros to Return ID for a CommandBar Control http://support.microsoft.com/default.aspx?kbid=213211 XL2000: Sample Macros to Return ID for a CommandBar Control -- HTH RP (remove nothere from the email address if mailing direct) "Mircea Pleteriu" wrote in message ... I know that each control (menu option) has a number assign to it. Where from can I get this map? Thanks, Mircea |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Map of controls-numbers
I think it is the same as Excel 2000. I gave the 97 and 2000 links as I
think some changed after XL97. -- HTH RP (remove nothere from the email address if mailing direct) "Mircea Pleteriu" wrote in message ... Is there no list of ID numbers for Excel 2002(3) ?!? "Bob Phillips" wrote in message ... Mircea, Here is a starter for you http://support.microsoft.com/default.aspx?kbid=159466 XL97: List of ID Numbers for Built-In Command Bar Controls http://support.microsoft.com/default.aspx?kbid=213552 XL2000: List of ID Numbers for Built-In CommandBar Controls http://support.microsoft.com/default.aspx?kbid=162814 XL97: Sample Macros to Return ID for a CommandBar Control http://support.microsoft.com/default.aspx?kbid=213211 XL2000: Sample Macros to Return ID for a CommandBar Control -- HTH RP (remove nothere from the email address if mailing direct) "Mircea Pleteriu" wrote in message ... I know that each control (menu option) has a number assign to it. Where from can I get this map? Thanks, Mircea |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Map of controls-numbers
The article says that File.Save As has the ID of 748.
But my code crashes for this code. Somebody else on another forum said that 5 is the correct ID for File.Save As. I tested and I worked. I'm confused about that. "Bob Phillips" wrote in message ... I think it is the same as Excel 2000. I gave the 97 and 2000 links as I think some changed after XL97. -- HTH RP (remove nothere from the email address if mailing direct) "Mircea Pleteriu" wrote in message ... Is there no list of ID numbers for Excel 2002(3) ?!? "Bob Phillips" wrote in message ... Mircea, Here is a starter for you http://support.microsoft.com/default.aspx?kbid=159466 XL97: List of ID Numbers for Built-In Command Bar Controls http://support.microsoft.com/default.aspx?kbid=213552 XL2000: List of ID Numbers for Built-In CommandBar Controls http://support.microsoft.com/default.aspx?kbid=162814 XL97: Sample Macros to Return ID for a CommandBar Control http://support.microsoft.com/default.aspx?kbid=213211 XL2000: Sample Macros to Return ID for a CommandBar Control -- HTH RP (remove nothere from the email address if mailing direct) "Mircea Pleteriu" wrote in message ... I know that each control (menu option) has a number assign to it. Where from can I get this map? Thanks, Mircea |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Map of controls-numbers
I haven't found anything about changes (apart from the structure of Autosum,
and I have just tested it on XL 2000 and 2002, and on both SaveAs has an id of 748. -- HTH RP (remove nothere from the email address if mailing direct) "Mircea Pleteriu" wrote in message ... The article says that File.Save As has the ID of 748. But my code crashes for this code. Somebody else on another forum said that 5 is the correct ID for File.Save As. I tested and I worked. I'm confused about that. "Bob Phillips" wrote in message ... I think it is the same as Excel 2000. I gave the 97 and 2000 links as I think some changed after XL97. -- HTH RP (remove nothere from the email address if mailing direct) "Mircea Pleteriu" wrote in message ... Is there no list of ID numbers for Excel 2002(3) ?!? "Bob Phillips" wrote in message ... Mircea, Here is a starter for you http://support.microsoft.com/default.aspx?kbid=159466 XL97: List of ID Numbers for Built-In Command Bar Controls http://support.microsoft.com/default.aspx?kbid=213552 XL2000: List of ID Numbers for Built-In CommandBar Controls http://support.microsoft.com/default.aspx?kbid=162814 XL97: Sample Macros to Return ID for a CommandBar Control http://support.microsoft.com/default.aspx?kbid=213211 XL2000: Sample Macros to Return ID for a CommandBar Control -- HTH RP (remove nothere from the email address if mailing direct) "Mircea Pleteriu" wrote in message ... I know that each control (menu option) has a number assign to it. Where from can I get this map? Thanks, Mircea |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Map of controls-numbers
This is my code which handles the Save As option.
// Disable "Save As" menu option this.excelApp.CommandBars["File"].Controls[5].Enabled = false; The code crashes with "Invalid index" if I use 748 instead of 5. Am I missing something? "Bob Phillips" wrote in message ... I haven't found anything about changes (apart from the structure of Autosum, and I have just tested it on XL 2000 and 2002, and on both SaveAs has an id of 748. -- HTH RP (remove nothere from the email address if mailing direct) "Mircea Pleteriu" wrote in message ... The article says that File.Save As has the ID of 748. But my code crashes for this code. Somebody else on another forum said that 5 is the correct ID for File.Save As. I tested and I worked. I'm confused about that. "Bob Phillips" wrote in message ... I think it is the same as Excel 2000. I gave the 97 and 2000 links as I think some changed after XL97. -- HTH RP (remove nothere from the email address if mailing direct) "Mircea Pleteriu" wrote in message ... Is there no list of ID numbers for Excel 2002(3) ?!? "Bob Phillips" wrote in message ... Mircea, Here is a starter for you http://support.microsoft.com/default.aspx?kbid=159466 XL97: List of ID Numbers for Built-In Command Bar Controls http://support.microsoft.com/default.aspx?kbid=213552 XL2000: List of ID Numbers for Built-In CommandBar Controls http://support.microsoft.com/default.aspx?kbid=162814 XL97: Sample Macros to Return ID for a CommandBar Control http://support.microsoft.com/default.aspx?kbid=213211 XL2000: Sample Macros to Return ID for a CommandBar Control -- HTH RP (remove nothere from the email address if mailing direct) "Mircea Pleteriu" wrote in message ... I know that each control (menu option) has a number assign to it. Where from can I get this map? Thanks, Mircea |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
Map of controls-numbers
That is because you are using an index, that is the 5th element in the
collection, not the id Try Set ctl = Application.CommandBars("File").FindControl(ID:=74 8) ctl.Enabled = False -- HTH RP (remove nothere from the email address if mailing direct) "Mircea Pleteriu" wrote in message ... This is my code which handles the Save As option. // Disable "Save As" menu option this.excelApp.CommandBars["File"].Controls[5].Enabled = false; The code crashes with "Invalid index" if I use 748 instead of 5. Am I missing something? "Bob Phillips" wrote in message ... I haven't found anything about changes (apart from the structure of Autosum, and I have just tested it on XL 2000 and 2002, and on both SaveAs has an id of 748. -- HTH RP (remove nothere from the email address if mailing direct) "Mircea Pleteriu" wrote in message ... The article says that File.Save As has the ID of 748. But my code crashes for this code. Somebody else on another forum said that 5 is the correct ID for File.Save As. I tested and I worked. I'm confused about that. "Bob Phillips" wrote in message ... I think it is the same as Excel 2000. I gave the 97 and 2000 links as I think some changed after XL97. -- HTH RP (remove nothere from the email address if mailing direct) "Mircea Pleteriu" wrote in message ... Is there no list of ID numbers for Excel 2002(3) ?!? "Bob Phillips" wrote in message ... Mircea, Here is a starter for you http://support.microsoft.com/default.aspx?kbid=159466 XL97: List of ID Numbers for Built-In Command Bar Controls http://support.microsoft.com/default.aspx?kbid=213552 XL2000: List of ID Numbers for Built-In CommandBar Controls http://support.microsoft.com/default.aspx?kbid=162814 XL97: Sample Macros to Return ID for a CommandBar Control http://support.microsoft.com/default.aspx?kbid=213211 XL2000: Sample Macros to Return ID for a CommandBar Control -- HTH RP (remove nothere from the email address if mailing direct) "Mircea Pleteriu" wrote in message ... I know that each control (menu option) has a number assign to it. Where from can I get this map? Thanks, Mircea |
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
Map of controls-numbers
from the immediate window:
? commandbars("File").Controls(5).Caption Save &As... ? commandbars("file").Controls(5).Id 748 5 is the position of it as a control in the default menu. 748 is its ID From Excel 2003 -- Regards, Tom Ogilvy "Mircea Pleteriu" wrote in message ... The article says that File.Save As has the ID of 748. But my code crashes for this code. Somebody else on another forum said that 5 is the correct ID for File.Save As. I tested and I worked. I'm confused about that. "Bob Phillips" wrote in message ... I think it is the same as Excel 2000. I gave the 97 and 2000 links as I think some changed after XL97. -- HTH RP (remove nothere from the email address if mailing direct) "Mircea Pleteriu" wrote in message ... Is there no list of ID numbers for Excel 2002(3) ?!? "Bob Phillips" wrote in message ... Mircea, Here is a starter for you http://support.microsoft.com/default.aspx?kbid=159466 XL97: List of ID Numbers for Built-In Command Bar Controls http://support.microsoft.com/default.aspx?kbid=213552 XL2000: List of ID Numbers for Built-In CommandBar Controls http://support.microsoft.com/default.aspx?kbid=162814 XL97: Sample Macros to Return ID for a CommandBar Control http://support.microsoft.com/default.aspx?kbid=213211 XL2000: Sample Macros to Return ID for a CommandBar Control -- HTH RP (remove nothere from the email address if mailing direct) "Mircea Pleteriu" wrote in message ... I know that each control (menu option) has a number assign to it. Where from can I get this map? Thanks, Mircea |
#11
Posted to microsoft.public.excel.programming
|
|||
|
|||
Map of controls-numbers
thanks a lot
"Bob Phillips" wrote in message ... That is because you are using an index, that is the 5th element in the collection, not the id Try Set ctl = Application.CommandBars("File").FindControl(ID:=74 8) ctl.Enabled = False -- HTH RP (remove nothere from the email address if mailing direct) "Mircea Pleteriu" wrote in message ... This is my code which handles the Save As option. // Disable "Save As" menu option this.excelApp.CommandBars["File"].Controls[5].Enabled = false; The code crashes with "Invalid index" if I use 748 instead of 5. Am I missing something? "Bob Phillips" wrote in message ... I haven't found anything about changes (apart from the structure of Autosum, and I have just tested it on XL 2000 and 2002, and on both SaveAs has an id of 748. -- HTH RP (remove nothere from the email address if mailing direct) "Mircea Pleteriu" wrote in message ... The article says that File.Save As has the ID of 748. But my code crashes for this code. Somebody else on another forum said that 5 is the correct ID for File.Save As. I tested and I worked. I'm confused about that. "Bob Phillips" wrote in message ... I think it is the same as Excel 2000. I gave the 97 and 2000 links as I think some changed after XL97. -- HTH RP (remove nothere from the email address if mailing direct) "Mircea Pleteriu" wrote in message ... Is there no list of ID numbers for Excel 2002(3) ?!? "Bob Phillips" wrote in message ... Mircea, Here is a starter for you http://support.microsoft.com/default.aspx?kbid=159466 XL97: List of ID Numbers for Built-In Command Bar Controls http://support.microsoft.com/default.aspx?kbid=213552 XL2000: List of ID Numbers for Built-In CommandBar Controls http://support.microsoft.com/default.aspx?kbid=162814 XL97: Sample Macros to Return ID for a CommandBar Control http://support.microsoft.com/default.aspx?kbid=213211 XL2000: Sample Macros to Return ID for a CommandBar Control -- HTH RP (remove nothere from the email address if mailing direct) "Mircea Pleteriu" wrote in message ... I know that each control (menu option) has a number assign to it. Where from can I get this map? Thanks, Mircea |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
using gui controls | Excel Discussion (Misc queries) | |||
ActiveX Controls vs Form Controls | Excel Discussion (Misc queries) | |||
Event procedures for controls added with Controls.Add | Excel Programming | |||
line controls | Excel Programming | |||
controls | Excel Programming |