vba - Addin to install other addins on installation won't open them -


i wrote addin, adds other addins on installation, because deploying 1 addin easier deploying whole bunch of addins.

problem: after end sub of workbook_addininstall() of bootloader-addin, added/installed addin dissapear vbe, , aren't installed anymore. still added addins-menu.

question: can install every addin hand on every pc because ain't big number, still bugs me can't seem find faulty line. i'd appreciate every idea comes mind me solve problem.

bootloader addin:

private sub workbook_addininstall()     const aicount integer = 2     dim ai      addin     dim aitmp   addin      dim       integer     dim aipath  string      dim aitobeinstalled(1 aicount) string     dim aiinstalled(1 aicount)     boolean      aitobeinstalled(1) = "addin1.xla"     aitobeinstalled(2) = "addin2.xla"      'addin added?     each ai in addins         = 1 aicount             if ai.name = aitobeinstalled(i)                 set aitmp = ai                 aitmp.installed = true                 aiinstalled(i) = true                 exit             end if         next     next ai      'add not added addins     = 1 aicount         if not aiinstalled(i)             aipath = getdrivepath(volname:="somevolname", excludedrives:="d") & _                                 "hidden\" & aitobeinstalled(i)             set ai = addins.add(aipath, false)             ai.installed = true         end if     next      set ai = nothing     set aitmp = nothing end sub ' after "end sub" addins still added not installed.

something interesting after installation of bootloader if run sub per f5, sub adds addins fine. , behaves you'd expect to.

edit: there no crucial things called on workbook_addininstall of addins being installed, changes menu. seeing that, confuses me. behaves if addins aren't associated application won't stay.

conclusion: far can go, if have ideas please let me know. working on workaround i'd want why doesn't work.

you need install add-in via vb editor current workbook project. .install() method register new guid in registry (as com object library) doesn't persist workbook reference.. 

'//start code snippet   '--!!-->   add reference workbook (on each computer).      '-->    if reference not registered (will/should) take      '-->    care of you..  application.vbe.activevbproject.references.addfromfile :your_file_path_here   '//end code snippet

obviously, replace :your_file_path_here path of addin location... let me know if helps. have few more tricks if doesn't. thanks, brian.


Comments

Post a Comment

Popular posts from this blog

assembly - 8086 TASM: Illegal Indexing Mode -

this question has answer here: illegal use of register in indirect addressing 1 answer i writing 8086 assembly program needs compile through tasm v3.1. running error can not seem fix. my data segment has following set purposes of keyboard input: parao label byte maxo db 5 acto db ? datao db 5 dup('$') what trying first character entered, first byte of datao: lea dx, datao mov bl, [dx] however, when attempt compile, error: **error** h5.asm(152) illegal indexing mode line 152 "mov bl, [dx]" any appreciated. if matters, running tasm through dosbox (my laptop running 64-bit win7) google hasn't come helpful answers. can post entirety of code if necessary. pretty sure reason can't use dx register pointer. try instead using [si], [di] or [bx]: lea bx, data0 mov al, [bx]
Read more

Java, LWJGL, OpenGL 1.1, decoding BufferedImage to Bytebuffer and binding to OpenGL across classes -

i've been attempting solve problem without luck. have 4 classes, main class, object class, sprite class , image loader class. i'm attempting load png using image loader , using method found here: http://www.java-gaming.org/topics/bufferedimage-to-lwjgl-texture/25516/msg/220280/view.html#msg220280 convert bytebuffer, , bind opengl. the image in it's own seperate resource folder. should being drawn this: ( http://i.imgur.com/j8gbu4c.png ) (32x32), i'm seeing white box has dimensions of image, not actual texture. if has idea of go fix i'd appreciate it. i'm new opengl , looking avoid using external library in order learn how actual code works. thanks. updated! to following, implemented suggestion provided vallentin, quad taking color of first pixel in image. i've attempted implementing image loader provided c.s here . i'm receiving error: javax.imageio.iioexception: error reading png image data @ com.sun.imageio.plugins.png.pngimagereader.r...
Read more

javascript - addthis share facebook and google+ url -

i attempting use addthis create simple url shares whichever current page user on when click share button. of right now, have twitter working. when user clicks, able see url populated in tweet box. when user clicks facebook or google+, url doesn't seem show in share box. <ul class="addthis_toolbox addthis_default_style "> <li><a class="addthis_button_facebook"><img src="/img/facebook-social.png" width="20" height="20" border="0" alt="share" /></a></li> <li><a class="addthis_button_twitter"><img src="/img/twitter-social.png" width="20" height="20" border="0" alt="share" /></a></li> <li><a class="addthis_button_google_plusone_share"><img src="/img/google-social.png" width="20" height="20" border="0" alt="s...
Read more