Solved

How to register a DLL in Excel 2007

Posted on 2011-02-28
11
548 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 50 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
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!

 
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 75 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

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

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

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

705 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