Error: "Compile error in hidden module: Main"
 

Hi,

I get an error while trying to install a third party Excel add-in [Thomson
One Analytics].
Error: "Compile error in hidden module: Main" Microsoft Excel 2003

But when I had the Addin unlocked I noticed that it was getting stuck at a
specific line in the MAIN module of the Addin package and the debugger throws
a compile error message saying that:
"Object library Invalid or contains references to object definitions that
could not be found"

Earlier when I had this issue, I made another user login to the PC and we
were able to use the add-in successfully. But this time even a different user
with Admin Rights was not able to use it.


Technical Specifications:
OS : Win Xp SP3
Ms Office : 2003 Professional - SP3


Trouble shooting done so far:
Tried to install and run the Addin on the same computer by a different user
having admin rights, no go
Made sure that he references for the add-in in the VBA editor are correct,
by comparing them with a working computer, no go
Re-installed "Service Pack 6 for Visual Basic 6.0: Run-Time Redistribution
Pack (vbrun60sp6.exe)", no go
Ran repairs on Excel, no go
Re-installed Excel, no go

Error: "Compile error in hidden module: Main"
 

You probably need to add the addin Analysis Toolpack and the VBA analysis
toolpack

"manish rajput" wrote:

Hi,

I get an error while trying to install a third party Excel add-in [Thomson
One Analytics].
Error: "Compile error in hidden module: Main" Microsoft Excel 2003

But when I had the Addin unlocked I noticed that it was getting stuck at a
specific line in the MAIN module of the Addin package and the debugger throws
a compile error message saying that:
"Object library Invalid or contains references to object definitions that
could not be found"

Earlier when I had this issue, I made another user login to the PC and we
were able to use the add-in successfully. But this time even a different user
with Admin Rights was not able to use it.


Technical Specifications:
OS : Win Xp SP3
Ms Office : 2003 Professional - SP3


Trouble shooting done so far:
Tried to install and run the Addin on the same computer by a different user
having admin rights, no go
Made sure that he references for the add-in in the VBA editor are correct,
by comparing them with a working computer, no go
Re-installed "Service Pack 6 for Visual Basic 6.0: Run-Time Redistribution
Pack (vbrun60sp6.exe)", no go
Ran repairs on Excel, no go
Re-installed Excel, no go