Copy link to clipboard
Copied
Hi
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:
Sub Indesign()
Dim InddApp As Indesign.Application
Set InddApp = CreateObject("InDesign.Application.2022")
End Sub
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.
Can someone please guide us?
Thanks
Copy link to clipboard
Copied