Opening Indesign App from Excel VBA Macro

New Here ,
Jul 09, 2022 Jul 09, 2022

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.

https://community.adobe.com/t5/indesign-discussions/cannot-establish-com-application-object-quot-ind...

 

Can someone please guide us?

 

Thanks

 

TOPICS
Scripting

Views

54

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines

correct answers 1 Correct answer

Guru , Jul 10, 2022 Jul 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.

Likes

Translate

Translate
Guru ,
Jul 10, 2022 Jul 10, 2022

Copy link to clipboard

Copied

LATEST

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.

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines