In several previous posts, many of you will be aware that I have
managed to devolve most (95%) of the VBA code belonging to a large
Excel application from the workbook into a DLL, which I produced using
VB6 from Visual Studio 6.

The success of this enterprise has been furthered by help obtained in
this forum. The resultant workbook/DLL does not interfere with any
other Excel workbook that the user opens or saves.

The DLL includes a number of forms.

On one of the forms I should like to display the version number
(major, minor and revision) of the DLL in which it is contained when
the spreadsheet is used. The values are set up on compilation,
optionally using auto-increment, on Project | Project Properties |
Make.

Do you know how I might do this? I presume that I will need an API
function.

Best wishes and thanks.

On 15 Dec, 11:12, JAC wrote:
In several previous posts, many of you will be aware that I have
managed to devolve most (95%) of the VBA code belonging to a large
Excel application from the workbook into a DLL, which I produced using
VB6 from Visual Studio 6.

The success of this enterprise has been furthered by help obtained in
this forum. The resultant workbook/DLL does not interfere with any
other Excel workbook that the user opens or saves.

The DLL includes a number of forms.

On one of the forms I should like to display the version number
(major, minor and revision) of the DLL in which it is contained when
the spreadsheet is used. The values are set up on compilation,
optionally using auto-increment, on Project | Project Properties |
Make.

Do you know how I might do this? I presume that I will need an API
function.

Best wishes and thanks.

With the aid of some advice from a friend, I have managed to resolve
this problem satisfactorily without direct recourse to Windows API
functions.

This may be useful to other members in the forum/group. I hope so.

Everything I needed (major, minor and revision numbers) are accessible
via the App class, including additional material like Copyright
notice, helpfile, etc.