Reference Set Points to Wrong File Location | Adobe AFormAut 1.0 Type Library

    For some time now we have been using code that leverages the Adobe AFormAut 1.0 Type Library reference located in this folder:


    "C:\Program Files (x86)\Adobe\Acrobat 2017\Acrobat\plug_ins\AcroForm.api"


    We recently upgraded to Adobe Acrobat 2020 so this reference should not be set to:


    "C:\Program Files (x86)\Adobe\Acrobat 2020\Acrobat\plug_ins\AcroForm.api"


    However, our company pushed Adobe Reader to many machines and now the Excel VBA reference points to "AcroForm.api" file located in the Reader folder structure.


    No matter what I do I cannot set the reference to the api file in the 2020 folder. Tried to set it via code and still no luck.


    Any suggestions on how to fix this?

    Can you late bind the code and skip the reference altogether?

    Rory
    Theory is when you know something, but it doesn’t work. Practice is when something works, but you don’t know why. Programmers combine theory and practice: nothing works and they don’t know why