?
Solved

How to register a DLL in Excel 2007

Posted on 2011-02-28
11
Medium Priority
?
552 Views
Last Modified: 2012-05-11
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
Comment
Question by:jgroetch
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 4
11 Comments
 
LVL 30

Expert Comment

by:SiddharthRout
ID: 35000862
0
 
LVL 10

Assisted Solution

by:GlobaLevel
GlobaLevel earned 150 total points
ID: 35000906
tyr this if Sid's option doesnt pan out:
http://msdn.microsoft.com/en-us/library/bb687915.aspx
0
 
LVL 1

Author Comment

by:jgroetch
ID: 35000971
thanks, I'll experiment with that code and let you know.
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 1

Author Comment

by:jgroetch
ID: 35001066
this line not working in excell 2007:

    Dim VBAEditor As VBIDE.VBE

VBIDE.VBE must have a different type now...
0
 
LVL 30

Expert Comment

by:SiddharthRout
ID: 35001144
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
 
LVL 1

Author Comment

by:jgroetch
ID: 35001723
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
 
LVL 30

Accepted Solution

by:
SiddharthRout earned 225 total points
ID: 35001750
But if you distribute your file with the above reference (VBAE) ticked then they will not have to :)

Sid
0
 
LVL 1

Author Comment

by:jgroetch
ID: 35007628
Yes that's true. I finally noticed that yesterday upon ticking another option.
0
 
LVL 30

Expert Comment

by:SiddharthRout
ID: 35008017
So what was the final outcome?

Sid
0
 
LVL 1

Author Comment

by:jgroetch
ID: 35009040
I will let you know...
0
 
LVL 1

Author Closing Comment

by:jgroetch
ID: 35083349
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

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question