I have a worksheet that uses MS Outlook Object Library to send one sheet of the workbook via Outlook email. I have code written to load MS Outlook 14.0 Object Library (MS Excel 2010) and it works great. I distribute this workbook to other users, some of which run MS Excel 2007. MS Excel 2007 uses MS Outlook 12.0 Object Library. I want to add code to my macro that will load the proper Object Library based on the version being used. I need to add an 'on error then' statement to my existing code. In other words if Object Library 14.0 is not found, then load Object Library 12.0. This will cover all my users versions. I will need to know where the Object Library 12.0 is located in the registry. See my current code that loads Object Library 14.0 below. Thanks in advance.
Bookmarks