asked on

Quite hard - version numbers

I have a dll created in VB and an Excel spreadsheet. I need to extract the version number of each application of which I normally use App.Major/Minor/Revision in the VBP (before it was made into a DLL) and a user-defined function in the spreadsheet that returns the hardcoded version number (public constant) of that spreadsheet. How do I return these values without having to open the applications ?

timjc

ASKER

Also what I forgot to mention is that the Spreadsheet is a DLL in 97 (basically a spreadsheet that has been saved as a DLL which just means it's invisible to the user but the functions and methods can still be used).

Mirkwood

Don't understand.
Do you want the version number of a VB project or of a DLL.

timjc

ASKER

Sorry if I didn't explain clearly enough. I basically need the file attributes of the VB DLL in particular the version number. I also need access to one public function in an Excel 97 spreadsheet and have it return a value (in this case a constant indicating the version number). This information needs to be returned to a VB app. I would like the information to be extracted from the files without opening them.

ASKER CERTIFIED SOLUTION

Mirkwood

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

timjc

ASKER

Mirkwood, thanks for that, works like a treat for the VB DLL. However I may have confused the issue by stating that the Excel spreadsheet was a DLL. If you ignore that statement and just consider it as a normal spreadsheet, do you know how I can link into that spreadsheet, run a function that just returns a constant, and return that value to the running VB app.

Thanks again.

timjc

ASKER

Actually, I have asked the owner of the spreadsheet to put the version number in the Subject property. Hope that makes things a little easier

timjc

ASKER

I'll give you this one and ask the question separately because I've changed the question slightly