The following example uses the Version property to return the version number of the host application.
Debug.Print Application.VBE.Version