Page 1 of 2 12 LastLast
Results 1 to 15 of 18
  1. #1
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Denmark
    Posts
    347
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Powerpoint add-in, load on launch (WinXP / O2003)

    Hi,

    Got concept of add-ins in place for Excel and Word, not sure how they work in Powerpoint.
    Would like a custom commandbar to be created everytime Powerpoint is launched.

    Seems that this can be achieved with this snippet:
    AddIns.Add("generic.ppa").Loaded = True

    What puzzles me is where is this line to be placed and where are the .ppa file to be stored.
    eg. in Excel I would place it in add-ins folder, in library folder or in XLstart, in Word for instance in Startup or cross referenced as a template...

    How does this work for powerpoint...

    Thanks,
    Bests,
    RD


    PS: Wish there were a knob on the TV to turn up the intelligence. There's a knob called "brightness," but that doesn't work

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Powerpoint add-in, load on launch (WinXP / O2003)

    PowerPoint doesn't automatically load an add-in just because it's in a special folder; the user will have to install it using Tools | Add-Ins. The default location is Cocuments and Settings<username>Application DataMicrosoftAddins (language-dependent)

    See Create an ADD-IN with TOOLBARS that run macros for tips on creating an add-in for PowerPoint.

  3. #3
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Denmark
    Posts
    347
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Powerpoint add-in, load on launch (WinXP / O2003)

    Hi Hans,

    To make sure I understand you correctly...

    They work similar to Excel add-ins, but first time usage requires that user checks the add-in from the list box?
    - so contrary to Excel you cannot autoload a menu BEFORE user has checked it?

    What's then the point of my little piece of code, if user needs to interact anyway? (was cut from the MS help)
    - no facility similar to the auto regsvr32.exe?
    Bests,
    RD


    PS: Wish there were a knob on the TV to turn up the intelligence. There's a knob called "brightness," but that doesn't work

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Powerpoint add-in, load on launch (WinXP / O2003)

    PowerPoint does not have the equivalent of Word's Startup folder, or Excel's XLStart folder. So the user will have to load an add-in manually the first time. After that, it will be loaded automatically each time PowerPoint starts. In other words, the line

    AddIns.Add("generic.ppa").Loaded = True

    can only be used to load other add-ins from an add-in that has been loaded manually by the user. There may be ways to use a system policy to automate this, but I cannot help you with that.

  5. #5
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Denmark
    Posts
    347
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Powerpoint add-in, load on launch (WinXP / O2003)

    Hans,

    As always, thanks a zillion for an answer straight to the point - you just saved me a lot of time and brought some light to one of my dark corners

    ;o)
    Bests,
    RD


    PS: Wish there were a knob on the TV to turn up the intelligence. There's a knob called "brightness," but that doesn't work

  6. #6
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Denmark
    Posts
    347
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Powerpoint add-in, load on launch (WinXP / O2003)

    OK one more on the same note, I'm afraid.

    When macro is run menu creates nicely and works.
    Made it a .ppa and placed it in add-ins folder, went to "Tools" - "Add-ins", "Add-new" - added it and checked it. - so far so good.

    Closed powerpoint and relaunched - hoping to see my menu appear (public sub mnuToolbar_add)
    But only a blank space was there where toolbar had been present in earlier F5 - test runs.

    Is there an Autoopen or other type of event that needs to be triggered to call my menu that creates the custom commandbar or how is this sub called?
    Setting the add-in check boc does not seem to be enough - as if I'm still missing one step...
    Bests,
    RD


    PS: Wish there were a knob on the TV to turn up the intelligence. There's a knob called "brightness," but that doesn't work

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Powerpoint add-in, load on launch (WinXP / O2003)

    The article I referred to higher up in this thread explains what you must do: create an Auto_Open macro in the add-in. Please read the article carefully, it contains very useful info.

  8. #8
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Denmark
    Posts
    347
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Powerpoint add-in, load on launch (WinXP / O2003)

    Ooops,.

    Got carried away by nearly being there....

    - apologies
    Bests,
    RD


    PS: Wish there were a knob on the TV to turn up the intelligence. There's a knob called "brightness," but that doesn't work

  9. #9
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Denmark
    Posts
    347
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Powerpoint add-in, load on launch (WinXP / O2003)

    Hi Hans,

    Have read the article(s) carefully and followed it to the point.
    Add-in compiles without problems. PPA is created nicely. It's registered and checked in the Add'ins box, BUT...
    it does NOT load on Auto_open....("
    Bests,
    RD


    PS: Wish there were a knob on the TV to turn up the intelligence. There's a knob called "brightness," but that doesn't work

  10. #10
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Powerpoint add-in, load on launch (WinXP / O2003)

    What happens if you replace

    Application.AddIns("NM_Utilities.ppa").AutoLoad = msoTrue

    with

    Application.AddIns("NM_Utilities.ppa").Loaded = msoTrue

  11. #11
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Denmark
    Posts
    347
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Powerpoint add-in, load on launch (WinXP / O2003)

    Nothing I'm afraid... - no change.
    Bests,
    RD


    PS: Wish there were a knob on the TV to turn up the intelligence. There's a knob called "brightness," but that doesn't work

  12. #12
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Powerpoint add-in, load on launch (WinXP / O2003)

    Do you set the Visible property of the toolbar to True explicitly? Toolbars created in code are invisible by default.

  13. #13
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Denmark
    Posts
    347
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Powerpoint add-in, load on launch (WinXP / O2003)

    Yep, it's set to visible = true - line just after the Toolbar.add
    Bests,
    RD


    PS: Wish there were a knob on the TV to turn up the intelligence. There's a knob called "brightness," but that doesn't work

  14. #14
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Powerpoint add-in, load on launch (WinXP / O2003)

    Sorry, no idea then. It works for me.

  15. #15
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Powerpoint add-in, load on launch (WinXP / O2003)

    Could you attach either the .ppt from which you create the .ppa, or a text file with all relevant code?

Page 1 of 2 12 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •