Microsoft office xp pro w publisher 20026/23/2023 ![]() VbNewLine & "Error Desc: " & Err.Description GetEdition = "Post Office 2013: " & strERR_MSG GetEdition = "Pre Office 2000: " & strERR_MSG If you know a better way then please let me know.Ĭonst strERR_MSG As String = "Unable to determine edition" As far as I know, there isn’t a native member in the Excel object model which will tell you the Office edition, so I derive it by using the application version and product code (GUID). I’m not sure why this would be useful (perhaps to show as information on a userform?) but I duly obliged by writing the below code which I have now updated to handle Office 2013. A few years ago a user asked how to use VBA to determine the edition of the active session of Office.
0 Comments
Leave a Reply. |