<div>
See the link below. It might help.<br />
<br />
<a href="http://www.blueclaw-db.com/get_access_version_number.htm" rel="ugc">http://www.blueclaw-db.com/get_access_version_number.htm</a><br />
<br />
Sincerely,<br />
Ed
</div>


See the link below. It might help.

http://www.blueclaw-db.com/get_access_version_number.htm [http://www.blueclaw-db.com/get_access_version_number.htm]

Sincerely,
Ed

<div>
mark..., it works, thanks. I have applied it to Excel and Word, because they might JUST be different on a PC.<br />
<br />
peter
</div>


mark..., it works, thanks. I have applied it to Excel and Word, because they might JUST be different on a PC.

peter

<div>
MIND..., your stuff was helpful but not immediately applicable.
</div>


MIND..., your stuff was helpful but not immediately applicable.

<div>
<div class="content wysiwyg-content">
I have this app that is built out of Access 2007. It is runtimed and packaged and runs on User's computers. So Access will always be 2007 on that computer. <br />
<br />
How can I find out in VBA the version of the MS Office that lives on the computer where my app is installed? It could be anything from 2000 onwards...<br />
<br />
Many thanks.
</div>
</div>


I have this app that is built out of Access 2007. It is runtimed and packaged and runs on User's computers. So Access will always be 2007 on that computer. 

How can I find out in VBA the version of the MS Office that lives on the computer where my app is installed? It could be anything from 2000 onwards...

Many thanks.

Finding out what version of Office runs on a computer from Access VBa

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.