Skip to main content
Cookie4ddict
Cookie4ddict
Inspiring
September 29, 2011
Answered

[VBA] Excel -> Indesign: "Can't find project or library" - how to fix?

  • September 29, 2011
  • 3 replies
  • 1708 views

Good morning everybody!

My problem this time is something weird. I developed an VBA for getting values from an Excel-Worksheet to an InDesign-Document. With my PC all is working fine. But when I start the same sheet at the PC of my boss there is this Message: "Can't find project or library"

I tried following steps:

1. I relinked the library

2. I deleted the tbl file on my drive and created a new one by starting InDesign as administrator

3. I deleted every other script tbl file (those within the userprofiles) and recreated them by starting InDesign

4. I tried registering the tbl with regsvr32, but Windows always told me this file is not compatible

My boss and I are both working with Windows 7 64Bit. The only difference is, I'm working with ultimate and he is using professional.

Any suggestions how we can fix this problem?

With kind regards,

Steffi

This topic has been closed for replies.
Correct answer Cookie4ddict

Found the problem!

The other PC's I wanted the program to run needed the numeric values for the attributes.

For others with the same problem:

idUserInteractionLevels.idInteractWithAll = 1699311169

idUserInteractionLevels.idNeverInteract = 1699640946

idJavascript = 1246973031

3 replies

Cookie4ddict
Cookie4ddictAuthorCorrect answer
Inspiring
September 29, 2011

Found the problem!

The other PC's I wanted the program to run needed the numeric values for the attributes.

For others with the same problem:

idUserInteractionLevels.idInteractWithAll = 1699311169

idUserInteractionLevels.idNeverInteract = 1699640946

idJavascript = 1246973031

John Hawkinson
John Hawkinson
Inspiring
October 1, 2011

Well, that's not exactly "the problem," just an ugly workaround.

I think this means that InDesign's TLB is corrupt. Try searching the forum for "regenerate TLB"

Cookie4ddict
Cookie4ddictAuthor
Inspiring
September 29, 2011

I found out that there are only unfound libraries within this lines:

myIndesign.ScriptPreferences.UserInteractionLevel = idUserInteractionLevels.idNeverInteract
myIndesign.ScriptPreferences.UserInteractionLevel = idUserInteractionLevels.idInteractWithAll
myIndesign.DoScript ActiveWorkbook.Path + "/iScript/generateCompanyReport.jsx", idJavascript

Anybody who knows that problem?

Cookie4ddict
Cookie4ddictAuthor
Inspiring
September 29, 2011

I tested it with two other PC's. One of them with Office 2010, one with Office 2007. Both not working.
I developed with Office 2010.

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