compile error hidden module

What is the compile message you are receiving? If it has VBA code, if you hit debug what lines does it highlight?

Thanks for coming back to me schielrn

I've figured out that it is a missing OLE automation reference but whenever I try to add this reference in using the following code (which I have to do because we have users all over the country and I can't manage them all manually adding the reference) :

Application.VBE.ActiveVBProject.References.AddFromFile ("c:\windows\system32\stdole2.tlb")

I get an error messsage - name conflicts with existing module, project or object library!

Any ideas?

Cheers

Are you getting this message on a machine that doesn't already have the OLE Automation reference checked? If you are trying it on a machine that already has it installed I would assume it wouldn't work.

If I uncheck the reference box from within the visual basic editor it works, but if I try to run it again it gives me the error. Is that what you are encountering? You may want to put an on error resume next preceding it, just so it doesn't error if someone runs the file a second time.

Hope that helps.

Hi,
I have the same problem when I deliver a file (VBA protected) to my customer. On opening the model, a userform should load automatically but my customers say they have a message 'compile error in hidden module'. In the Excel-file, I have included references for example to OLE Automation and Solver that I suspect my client do not have by default. I cannot go to my client, open the protected VBA code and check those references. Is there a way to install the references to them automatically? The code: Application.VBE.ActiveVBProject.References.AddFromFile ("c:\windows\system32\stdole2.tlb") was mentioned here. Is that the way?