[ExcelVBA] Installing An Add-In

 

I'm probably missing something very simple here, but can somebody help me please.

I've written and tested an add-in (VBA code) which I've password protected and stored in a folder called "C:Program Files\Mysociety" and called the addin "Soc.xla"

Within the add-in, I have a routine called "UpdateMenu" which creates a menu in Excel with all the required routines in it.

The add-in works fine, but I now need to distribute it to a small group of colleagues who have limited computer skills.

I've written a short using the "Workbook_Open" procedure (in a stand alone install xlsm file) which registers the add-in OK, but I can't get the "UpdateMenu" routine in the add-in to execute from the Workbook_Open procedure.

I've tried all sorts of commands to try and get it to execute, but I've either got the sysntax wrong, or I'm trying to install it the wrong way.

Any suggestions please?

Also is there a way of creating an install exe to automate the whole install process

Regards,

Fred

[Non-text portions of this message have been removed]

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 7

Visit Your Group

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___