Would anybody be able to provide some assistance with assigning a user defined GUID to a template.
using code like
'Update the GUID you need below. strGUID = "{00020905-0000-0000-C000-000000000046}" 'Add the reference ThisWorkbook.VBProject.References.AddFromGuid _ GUID:=strGUID, Major:=0, Minor:=0
Background:
I am building a common reference library for Multiple MS host applications. The intention is to set the reference to this common reference library by VBA and permanent GUID.
It is already possible to add a reference from a file , but that provides no control over the actual GUID used. It is intended to add a known GUID to newly developed templates to reduce template bloat and template maintenace workload.
The critical part of this process is being able to transport this defined GUID between multiple systems.