| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Where can I find a full list of "mso" constants?
I've decided to change my COM add-in to use late binding, so I'm going
to change all my Excel types to Object and all my "mso" constants to their values. But going through and Debug.Print'ing all of them would be a real pain. Does anyone know where I can find a list of all the mso constants and their values? Thanks, Nick Hebb BreezeTree Software, LLC http://www.breezetree.com |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Where can I find a full list of "mso" constants?
On Chip Pearson's site, under the downloads page:
http://www.cpearson.com/excel/download.htm the last entry at the bottom of the page (xlconst) is for a workbook with constants listed. On the group page, the MSO constants start at row 1940. -- Regards, Tom Ogilvy "Nick Hebb" wrote in message oups.com... I've decided to change my COM add-in to use late binding, so I'm going to change all my Excel types to Object and all my "mso" constants to their values. But going through and Debug.Print'ing all of them would be a real pain. Does anyone know where I can find a list of all the mso constants and their values? Thanks, Nick Hebb BreezeTree Software, LLC http://www.breezetree.com |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Where can I find a full list of "mso" constants?
Download http://www.cpearson.com/Zips/XLConsts2.ZIP , unzip it,
and run he macro "List Excel Constants". This will list all xl and mso constants, both alphabetically and grouped by enum. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Nick Hebb" wrote in message oups.com... I've decided to change my COM add-in to use late binding, so I'm going to change all my Excel types to Object and all my "mso" constants to their values. But going through and Debug.Print'ing all of them would be a real pain. Does anyone know where I can find a list of all the mso constants and their values? Thanks, Nick Hebb BreezeTree Software, LLC http://www.breezetree.com |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Where can I find a full list of "mso" constants?
Thanks Chip and Tom. That's a great list. Unfortunately, it doesn't
list the msoShapes* constants, so I'll need to put together my own list. If you want to append it to your list, I can email it to you after I compose. Thanks, Nick Hebb BreezeTree Software, LLC http://www.breezetree.com |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Where can I find a full list of "mso" constants?
It does list the mso Shape constants, beginning on line 2342
(when the file is generated in Office 2003) on the Groups page. They're listed as part of the MsoAutoShapeType enum. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Nick Hebb" wrote in message ups.com... Thanks Chip and Tom. That's a great list. Unfortunately, it doesn't list the msoShapes* constants, so I'll need to put together my own list. If you want to append it to your list, I can email it to you after I compose. Thanks, Nick Hebb BreezeTree Software, LLC http://www.breezetree.com |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Where can I find a full list of "mso" constants?
Hi Nick,
I use a very un-sophisticated way to get constants, without going into tlb's. But it's only a one off exercise and quick & simple. Copy the list of constant names from help into cells, arrange and sort into one column, say in col B, with no empty cells C1 ="Cells("& ROW() &",1) = " & B1 autofill down Paste what's in col C into an empty Sub & run For the msoShapes, type "AutoShapeType" in a module, select & F1 Regards, Peter T "Nick Hebb" wrote in message ups.com... Thanks Chip and Tom. That's a great list. Unfortunately, it doesn't list the msoShapes* constants, so I'll need to put together my own list. If you want to append it to your list, I can email it to you after I compose. Thanks, Nick Hebb BreezeTree Software, LLC http://www.breezetree.com |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Where can I find a full list of "mso" constants?
There was a bug that caused their omission from the Alpha page.
Re-download the file from the web site and re-run the "ListExcelConstants" macro. "Nick Hebb" wrote in message ups.com... Thanks Chip and Tom. That's a great list. Unfortunately, it doesn't list the msoShapes* constants, so I'll need to put together my own list. If you want to append it to your list, I can email it to you after I compose. Thanks, Nick Hebb BreezeTree Software, LLC http://www.breezetree.com |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Where can I find a full list of "mso" constants?
Thanks again Chip.
I get a "programmatic access not trusted" error on this line: Set TLInfo_XL = TLApp.TypeLibInfoFromFile(ThisWorkbook.VBProject.R eferences("EXCEL").FullPath) I'm don't know a great deal about security settings, so someone sharper could probably find a way around it. It didn't matter, though since the new version was fully populated. Nick Hebb BreezeTree Software, LLC http://www.breezetree.com |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Where can I find a full list of "mso" constants?
You need to go to the Tools menu, choose Macros, then Security.
In that dialog, choose the Trusted Sources tab, and check the "Trust access to Visual Basic project" setting. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Nick Hebb" wrote in message oups.com... Thanks again Chip. I get a "programmatic access not trusted" error on this line: Set TLInfo_XL = TLApp.TypeLibInfoFromFile(ThisWorkbook.VBProject.R eferences("EXCEL").FullPath) I'm don't know a great deal about security settings, so someone sharper could probably find a way around it. It didn't matter, though since the new version was fully populated. Nick Hebb BreezeTree Software, LLC http://www.breezetree.com |
|
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Where can I find a full list of "mso" constants?
That worked.
I assume Excel is pretty "constant" about its constants, i.e., it may add new ones with each version but doesn't change old ones? |
|
#11
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Where can I find a full list of "mso" constants?
MS wouldn't change the value of any existing constant, but will
certainly add new ones as the need arises. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Nick Hebb" wrote in message oups.com... That worked. I assume Excel is pretty "constant" about its constants, i.e., it may add new ones with each version but doesn't change old ones? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "Disk is Full" add-on question to "Can't reset last cell" post tod | Excel Discussion (Misc queries) | |||
| HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
| Can I have in Excel SQL query computed constants like "? as Col1" | Excel Discussion (Misc queries) | |||
| Find "." (Full Stop) in cell then all text after colour blue | Excel Programming | |||
Linear Mode
