I currently have a Microsoft Excel 2016 XLAM file with VBA designed determine if another loaded XLAM has an updated file intended to replace it. In total, there are two XLAM files (plus the potentially updated XLAM).
Three XLAM files:
1. Loader xlam (loaded/enabled in Excel)
2. Core xlam (loaded/enabled in Excel)
3. Updated Core xlam (saved in local folder. Evaluated by Loader---if newer than current loaded Core, uninstall the core and replace it and enable)
I only require the Loader xlam to be converted to a COM addin via Visual Studio 2016, vb.net. There are no changes to functionality to the loader----only a straight conversion to COM addin is required.
I am the author of all the VBA and am fairly decent with the language and Excel (10+ years experience). In addition to receiving a functioning COM addin (loader xlam conversion), I intend to use the resulting visual studio project to learn. The Loader xlam is not complicated----it checks the (new) core xlam's file name to determine a version (eg, [login to view URL]). If a relate registry key is older (eg, 220.127.116.11), the loader then processes the file update. Unloads the current core xlam, copies the new core xlam (18.104.22.168) to the addins folder and loads/enables the addin.
Visual Studio 2017 solution (VSTO) using Visual Basic
7 freelancers are bidding on average $149 for this job
I am good at Excel formula and VBA/Macro, I need to see the data so I can understand your requirement, I might have a few question to discuss so I need you to send a message on chat.