×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Embedding add-in into Excel worksheet

Embedding add-in into Excel worksheet

Embedding add-in into Excel worksheet

(OP)
I use a number of Excel add-ins (.xla) including some I have downloaded and some I have written.  I don’t have access to the code for the ones I downloaded.

I have had difficulty sharing Excel worksheet files (.xls) with clients when the worksheet files use the add-ins.  My understanding is that if the .xla file is put in the /.../xlstart/  directory, the add-in should load every time Excel starts, and worksheets using the add-in should work.  Seems to work this way on my computer, but my clients have not been able to get them to work.  Am I doing something wrong?  Is there a way to embed the add-in into the worksheet, so the user (and I) do not have to bother with the separate .xla file?

RE: Embedding add-in into Excel worksheet

One possible solution is to establish a reference to the addin in the workbook you will distribute.  This is done by using the Tools:References menu item from within the Visual Basic Editor.  In the References Dialogue click the browse button and navigate to the directory containing the Addin and then select it.

In the project window you will now see a new branch on the project tree called "References" with a leaf called "References to XXX" where XXX is you addin name.  This technique is called early binding.  It should only be used if you are sure the addin will be located in the directory you poined to.

Now user defined functions inthe addin can be called just as if the addin were

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources