Excel Addin Support about code

When doing Add-ins for Microsoft Excel, Microsoft Word, Microsoft Outlook or other Office VBA, you often want to know what your client is running.

We add an about button to the ribbon or toolbar as follows:

Public Sub SystemVersion()

    MsgBox "Version " & g_sVersion & vbNewLine & vbNewLine & _
    ThisWorkbook.Path & "\" & ThisWorkbook.Name & vbNewLine & vbNewLine & _
    "Excel Version " & Application.Version & "." & Application.Build & vbNewLine & _
    "Running on " & Application.OperatingSystem & vbNewLine & vbNewLine & _
    "MacroView Business Technology" & vbNewLine & _
    "Solutions for SharePoint and Office" & vbNewLine & _
    "http://www.macroview.com.au", vbOKCancel, g_sSystemName
   
End Sub

As you can see, this shows the excel version, the build and the version of Windows as well as the location and the add-in version. It makes diagnosing what is wrong just that little bit easier.