How to register a DLL in Excel 2007

We are rolling out an Excel 2007 xlsm project to users at the client which requires a DLL to be registered in Excel.
We find that we CANNOT regsiter the dll via command prompt regsvr32, but rather only via the Excel IED (alt+f11, then tools/references).

Question: is there any way to do this via a VBA macro ? Or perhaps through a windows script ?

thank you in advanced.
Bob
LVL 1
jgroetchAsked:
Who is Participating?
 
SiddharthRoutConnect With a Mentor Commented:
But if you distribute your file with the above reference (VBAE) ticked then they will not have to :)

Sid
0
 
SiddharthRoutCommented:
0
 
GlobaLevelConnect With a Mentor ProgrammerCommented:
tyr this if Sid's option doesnt pan out:
http://msdn.microsoft.com/en-us/library/bb687915.aspx
0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
jgroetchAuthor Commented:
thanks, I'll experiment with that code and let you know.
0
 
jgroetchAuthor Commented:
this line not working in excell 2007:

    Dim VBAEditor As VBIDE.VBE

VBIDE.VBE must have a different type now...
0
 
SiddharthRoutCommented:
You have to set a reference to "Microsoft Visual basic  for Applications Extensibility x.x" Object.

You can do that by clicking on the menu Tools~~> References in the VBA Editor.

Sid
0
 
jgroetchAuthor Commented:
Thank you for that. That's still one more manual step we are trying to avoid; however thank you anyway for your response.
In the end, I believe the users will HAVE TO manually add the DLL via Tools/References in VBA IDE.
0
 
jgroetchAuthor Commented:
Yes that's true. I finally noticed that yesterday upon ticking another option.
0
 
SiddharthRoutCommented:
So what was the final outcome?

Sid
0
 
jgroetchAuthor Commented:
I will let you know...
0
 
jgroetchAuthor Commented:
Thank you gentlemen for your response.
We're unfortunately going for the step-by-step manual process at the client site. That is, locating the correct version of the DDL, then having the client register in Excel manually.
Regards,
Bob
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.