References - VBAProject
Hi,
I have both Adobe DC and Acrobat 2020 installed on my laptop. When I reference a VBAProject in an excel sheet, it always link to Adobe DC but not Acrobat 2020, seems like by default. Adobe DC is under C:\Program Files while Acrobat 2020 is under C:\Program Files (x86)\Adobe\Acrobat 2020. Is this the way it should be? or is there anything I can do to make it link to Acrobat 2020? Aparently, it reads the below codes well before reading the highlighted one. I got a Run-time error '429' ActiveX component can't create object when I run the highlighted code.
Any help will be greatly appreciated!
Thanks,
Simon


