How to ensure custom Excel application's latest version?

S

Sean

I have written a custom VBA Excel application that works as a report
writer. The app uses SQL and MDX to build a local Excel report book
using custom menu options. I currently have the application loaded on
each client computer which, as the application's visibility has
increased, is now unmanageable.

I am looking for a recommendation to maintain the current version of
the custom application across the enterprise. I am about to implement
a table in SQL Server which contains the name of each custom
application and its current version. On opening, each custom
application would check its version and stop processing if version not
current. I wanted to run this by the experts on this group to see if
you can recommend a better solution or best practice.

Thanks in advance for your time.

Regards,
Sean
 
Top