I have references that use API library to interact with other software.
I have multiple different versions of this software installed in my computer, lets say ProgramA 2021 and ProgramA 2022.
The paths of reference are:
"C:\Program Files\CompanyX\ProgramA 2021\ProgramAv1.tlb"
"C:\Program Files\CompanyX\ProgramA 2022\ProgramAv1.tlb"
So the folder are different, but reference file name and description are same.
The problem is I cannot change the reference to older version (either manually by VBE interface tools->reference->browse, or by coding using Ms VBA Extensibility 5.3 library), hence I connect to the older software by API.
Is there possible solution from excel VBA side? Or this is purely issue from that software (e.g. the software have only one reference GUID that overwrites all older versions during installation)?
TIA
I have multiple different versions of this software installed in my computer, lets say ProgramA 2021 and ProgramA 2022.
The paths of reference are:
"C:\Program Files\CompanyX\ProgramA 2021\ProgramAv1.tlb"
"C:\Program Files\CompanyX\ProgramA 2022\ProgramAv1.tlb"
So the folder are different, but reference file name and description are same.
The problem is I cannot change the reference to older version (either manually by VBE interface tools->reference->browse, or by coding using Ms VBA Extensibility 5.3 library), hence I connect to the older software by API.
Is there possible solution from excel VBA side? Or this is purely issue from that software (e.g. the software have only one reference GUID that overwrites all older versions during installation)?
TIA