Copy link to clipboard
Copied
I run VBA scripts in Microsoft Excel 2010 that communicate with InDesign via COM Interface.
I did that successfully using InDesign CS4 and CS5, but with CS6 the Connection from Excel to the InDesign Application does not establish. The lines:
Dim InApp As InDesign.Application
Set InApp = CreateObject("InDesign.Application.CS6")
result in "error 13 type mismatch"
I checked the following
What to do?
Seem to have some answer...
go to this directory:
C:\ProgramData\Adobe\InDesign\Version 7.0\en_US\Scripting Support\7.0 (or where ever .tlb file is present)
And DELETE (or rename) the file "Resources for Visual Basic.tlb"
Launch InDesign by right-clicking and choosing "Run as Administrator".
This allows InDesign to make appropriate changes to the registry and who knows what else in the system.
You can then quit InDesign and launch it normally (I don't like running things as Admin as a rule).
Try your
...Copy link to clipboard
Copied
This is the same problem, I face, as well. I am also, looking for a solution, for this issue.
Copy link to clipboard
Copied
Seem to have some answer...
go to this directory:
C:\ProgramData\Adobe\InDesign\Version 7.0\en_US\Scripting Support\7.0 (or where ever .tlb file is present)
And DELETE (or rename) the file "Resources for Visual Basic.tlb"
Launch InDesign by right-clicking and choosing "Run as Administrator".
This allows InDesign to make appropriate changes to the registry and who knows what else in the system.
You can then quit InDesign and launch it normally (I don't like running things as Admin as a rule).
Try your script.
I got this from https://forums.adobe.com/thread/834780
Copy link to clipboard
Copied
Indeed this is the solution, valid for Indesign CS5 and CS6.
I might add that the connection does not establish when Indesign runs in admin mode. It MUST be reopened in normal mode after the tlb file is beeing rebuilt (or whatever happens there).
Copy link to clipboard
Copied
Hi Guys, not sure if this thread is dead, but I'm having a similar issue with Indesign 11.0/2015 and 12.0/2017 on two different systems, one Windows 10 and one Windows 7 SP2 (64)
The COM interface for Photoshop works perfectly, scripting away in Python, but InDesign is missing by default it seems.
Tried regtlibv12.exe on Windows 7, claims to successfully register, but says it has no property '_Application'.
Tried tlbimp.exe on Windows 10, says the interface isn't derived from IUnknown, so it skips it.
I'm trying to string some scripts together through Python with the comtypes lib, the dream was so close!
It launches InDesign but alas doesn't get the interface hooks in.
I've renamed the 'Resources for Visual Basic.dll' and regenerated it as Admin a couple of times. No joy there.
Also reinstalled a few times as admin to check. Still no joy.
It's the COM interface that was never meant to be I feel...
Any help appreciated!