It can sometimes be necessary to determine the version of the program you are working with in VBA and I have been unable to find a comprehensive listing. Microsoft themselves have scattered this information over numerous pages?! Here is what I have compiled myself thus far (Office 2000 through Office 2010 SP1).
| Application Name | Executable File | 2000 | 2000 SP1 | 2000 SP2 | 2000 SP3 | 2002 | 2002 SP1 | 2002 SP2 | 2002 SP3 | 2003 | 2003 SP1 | 2003 SP2 | 2003 SP3 | 2007 | 2007 SP1 | 2007 SP2 | 2007 SP3 | 2010 | 2010 SP1 |
| Microsoft Office | mso.dll | 10.0.2627.01 | 10.0.3520.0 | 10.0.4330.0 | 10.0.6626.0 | 11.0.5614.0 | 11.0.6361.0 | 11.0.7969.0 | 11.0.8173.0 | 12.0.4518.1014 | 12.0.6213.1000 | 12.0.6425.1000 | 14.0.4760.1000 | 14.0.6023.1000 | |||||
| Microsoft Access | msaccess.exe | 9.0.2720 | 9.0.3821 | 9.0.4402 | 9.0.6926 | 10.0.2627.1 | 10.0.3409.0 | 10.0.4302.0 | 10.0.6501.0 | 11.0.5614.0 | 11.0.6361.0 | 11.0.7969.0 | 11.0.8173.0 | 12.0.4518.1014 | 12.0.6211.1000 | 12.0.6423.1000 | 12.0.6606.1000 | 14.0.4750.1000 | 14.0.6024.1000 |
| Microsoft Binder | 9.0.2702 | 9.0.2702 | |||||||||||||||||
| Microsoft Excel | excel.exe | 9.0.2720 | 9.0.3821 | 9.0.4402 | 9.0.6926 | 10.0.2614.0 | 10.0.3506.0 | 10.0.4302.0 | 10.0.6501.0 | 11.0.5612.0 | 11.0.6355.0 | 11.0.7969.0 | 11.0.8173.0 | 12.0.4518.1014 | 12.0.6214.1000 | 12.0.6425.1000 | 12.0.6611.1000 | 14.0.4756.1000 | 14.0.6024.1000 |
| Microsoft FrontPage | frontpg.exe | 4.0.2.2720 | 4.0.2.3821 | 4.0.2.4426 | 4.0.2.6625 | 10.0.2623.0 | 10.0.3402.0 | 10.0.4128.0 | 10.0.6308.0 | 11.0.5516.0 | 11.0.6356.0 | 11.0.7969.0 | 11.0.8173.0 | ||||||
| Microsoft Groove | groove.exe | 12.0.4518.1014 | 12.0.6211.1000 | 12.0.6421.1000 | 12.0.6600.1000 | 14.0.4761.1000 | 14.1.6009.1000 | ||||||||||||
| Microsoft InfoPath | infopath.exe | 11.0.5531.0 | 11.0.6357.0 | 11.0.7969.0 | 11.0.8173.0 | 12.0.4518.1014 | 12.0.6214.1000 | 12.0.6413.1000 | 12.0.6606.1000 | 14.0.4763.1000 | 14.0.6009.1000 | ||||||||
| Microsoft OneNote | onenote.exe | 11.0.5614.0 | 11.0.6360.0 | 11.0.7969.0 | 11.0.8173.0 | 12.0.4518.1014 | 12.0.6211.1000 | 12.0.6415.1000 | 12.0.6606.1000 | 14.0.4763.1000 | 14.0.6022.1000 | ||||||||
| Microsoft Outlook | outlook.exe/outlib.dll | 9.0.0.2711 | 9.0.0.3821 | 9.0.0.4527 | 9.0.0.6627 | 10.0.2627.1 | 10.0.3416.0 | 10.0.4024.0 | 10.0.6626.0 | 11.0.5510.0 | 11.0.6353.0 | 11.0.7969.0 | 11.0.8173.0 | 12.0.4518.1014 | 12.0.6212.1000 | 12.0.6423.1000 | 12.0.6607.1000 | 14.0.4760.1000 | 14.0.6025.1000 |
| Microsoft PowerPoint | powerpnt.exe | 9.0.2716 | 9.0.3821 | 9.0.0.4527 | 9.0.6620 | 10.0.2623.0 | 10.0.3506.0 | 10.0.4205.0 | 10.0.6501.0 | 11.0.5529.0 | 11.0.6361.0 | 11.0.7969.0 | 11.0.8173.0 | 12.0.4518.1014 | 12.0.6211.1000 | 12.0.6425.1000 | 12.0.6600.1000 | 14.0.4754.1000 | 14.0.6026.1000 |
| Microsoft Project | winproj.exe | 10.0.2915.0 | 10.0.8326.0 | 11.0.5614.0 | 11.0.6707.0 | 11.0.7969.0 | 11.0.8173.0 | 12.0.4518.1014 | 12.0.6211.1000 | 12.0.6423.1000 | 14.0.4751.1000 | 14.0.6023.1000 | |||||||
| Microsoft Publisher | mspub.exe | 10.0.2621.0 | 10.0.3402.0 | 10.0.4016.0 | 10.0.6308.0 | 11.0.5525.0 | 11.0.6255.0 | 11.0.7969.0 | 11.0.8173.0 | 12.0.4518.1014 | 12.0.6211.1000 | 12.0.6423.1000 | 12.0.6606.1000 | 14.0.4750.1000 | 14.0.6026.1000 | ||||
| Microsoft SharePoint Designer | spdesign.exe | 12.0.4518.1014 | 12.0.6211.1000 | 12.0.6423.1000 | 14.0.4750.1000 | ||||||||||||||
| Microsoft Visio | vision.exe/vislib.dll | 10.0.525 | 10.1.2514 | 10.2.5110 | 11.0.3216.5614 | 11.0.4301.6360 | 11.0.7969.0 | 11.0.8173.0 | 12.0.4518.1014 | 12.0.6211.1000 | 12.0.6423.1000 | 14.0.4756.1000 | 14.0.6022.1000 | ||||||
| Microsoft Word | winword.exe | 9.0.2720 | 9.0.3821 | 9.0.4402 | 9.0.6926 | 10.0.2627.0 | 10.0.3416.0 | 10.0.4219.0 | 10.0.6612.0 | 11.0.5604.0 | 11.0.6359.0 | 11.0.7969.0 | 11.0.8173.0 | 12.0.4518.1014 | 12.0.6211.1000 | 12.0.6425.1000 | 12.0.6612.1000 | 14.0.4762.1000 | 14.0.6024.1000 |
Also, note that some of this information is impossible to find on any official website (but then again, why would I be writing such a post if it were!) so there could be mistakes. This is based on what I could find online and what I managed to piece together by looking over various computers. If you find mistakes, please use the contact form to send me an e-mail and I will make the necessary corrections promptly.
Here are a few of my references that I used to compile this list:
Office 2000
Office 2002 (Office XP)
Office 2003
Office 2007
General info on how to retrieve the Executable’s build number