Skip to main content
R
Rays LLC
New Participant
July 9, 2022
Answered

Opening Indesign App from Excel VBA Macro

  • July 9, 2022
  • 1 reply
  • 795 views

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.

https://community.adobe.com/t5/indesign-discussions/cannot-establish-com-application-object-quot-indesign-application-cs6-quot/td-p/6565213

 

Can someone please guide us?

 

Thanks

 

This topic has been closed for replies.
Correct answer Kasyan Servetsky

Try to do this (it worked for me when I had a similar problem).

Check out this function. It works well for me for years.

1 reply

Kasyan Servetsky
Kasyan ServetskyCorrect answer
Brainiac
July 10, 2022

Try to do this (it worked for me when I had a similar problem).

Check out this function. It works well for me for years.

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices