Error 13: Type mismatch

Question

I have a example Add ins of excel: I call object InDesign as:

 Private Sub btnStart_Click()
    Dim pCnt As Integer
    Dim myInDesign As InDesign.Application
    Dim myDoc As InDesign.Document
    Dim myPage As InDesign.Page

    ActiveWorkbook.Colors(17) = RGB(255, 204, 255)
    Set myInDesign = CreateObject("InDesign.Application")
    Set myDoc = myInDesign.ActiveDocument

    Set myInDesign = Nothing
    Set myDoc = Nothing

    Unload Me
End Sub

Show Error 13: Type mismatch at Set myInDesign = CreateObject("InDesign.Application")

Why? how fix? Thanks all.

Dim myInDesign as Object, or Set myInDesign = New InDesign.Application depending on your addon constructor — , Apr 16 '13 at 11:04
Or a shot in the dark `CreateObject("InDesign.Application.CS5")` if `CS5` is installed? — Siddharth Rout, Apr 16 '13 at 11:14

score 1 · Accepted Answer · answered Apr 23 '13 at 08:55

1

I find answer at http://forums.adobe.com/thread/834780

Delete file C:\ProgramData\Adobe\InDesign\Version 6.0\en_US\Scripting Support\6.0\Resources for Visual Basic.tlb And run excel and indesign with permission admin

answered Apr 23 '13 at 08:55

D T

3,522
7
45
89

Error 13: Type mismatch

1 Answers1