We need to open Adobe Indesign from Microsoft Excel VBA Macro and do various automated tasks on Adobe documents.
The Excel VBA code we are using is as follow:
Dim InddApp As Indesign.Application
Set InddApp = CreateObject("InDesign.Application.2022")
The code works fine and opens Adobe Indesign but then after opening the application it throws an error:
Run-time error '13': Type mismatch
This problem is discussed in earlier posts years ago (see one below) but the solution proposed requires us to delete a certain file in a certain directory. We are unable to find this file "Resources for Visual Basic.tlb" in Adobe Indesign 2022 folders anywhere and also the directory path they are showing does not exist in our addobe Indesign folders.