• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 556
  • Last Modified:

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
0
jgroetch
Asked:
jgroetch
  • 6
  • 4
2 Solutions
 
SiddharthRoutCommented:
0
 
GlobaLevelCommented:
tyr this if Sid's option doesnt pan out:
http://msdn.microsoft.com/en-us/library/bb687915.aspx
0
 
jgroetchAuthor Commented:
thanks, I'll experiment with that code and let you know.
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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
 
SiddharthRoutCommented:
But if you distribute your file with the above reference (VBAE) ticked then they will not have to :)

Sid
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

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 6
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now