+ Reply to Thread
Results 1 to 2 of 2

saving VBA as add-ins (xlam equivalent) for Word 2016

  1. #1
    Registered User
    Join Date
    12-08-2017
    Location
    Minneapolis, MN
    MS-Off Ver
    Standard 2013
    Posts
    83

    saving VBA as add-ins (xlam equivalent) for Word 2016

    I created a macro that extracts the current page in a word doc and saves it as a new file. I want to save this macro as an add in like I do with excel macros but I don't know how to do so. It seems quite different than excel and google is not providing quick answers. I tried saving the file as a .dotm. I was able to add it in the add-ins box and as a button in the ribbon, but it won't allow it to be run because it cannot be found or that it is disabled due to security settings. I have checked it as a document template in the developer tab.

    I read somewhere you can put your dotm file in the word parent directory to have it run automatically. the usual way I navigate to application directories is to right-click on the shortcuts on the desktop or wherever and click "open file location" but that's not working as it used to. It gets stuck in the startmenu>programs directory and doesn't take me any farther (i.e. to it's target). In the properties box, it says what it's target is "Microsoft Standard Office 2016", but not it's path. I don't recall ever having an issue with this procedure. Maybe it's because of a computer upgrade (I got a whole new faster machine plus some other versions of applications, but Windows 10 was on both). I suppose I can find the directory manually and I'll try this but I may not even be on the right track with this.

    Thank for your time and help

    Edit: The directory in my documents folder, Custom Office templates, where the dotm file is located is a trusted location (the normal method I use for getting around security as the office IT guy doesn't want us changing macro settings around).
    Last edited by foxtrotter; 05-01-2019 at 12:27 PM.

  2. #2
    Forum Expert macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,726

    Re: saving VBA as add-ins (xlam equivalent) for Word 2016

    Macros are commonly stored in Word's Normal template, from where they're available to all documents. If you only want a macro to be available to a certain group of documents, create a template containing the macro and attach those documents to that template (any documents created from the template will also be attached to it). You could also create your own Global template. A global template is a template (dotx or dotm file) stored in Word's Startup folder. To locate the Startup folder, see: http://www.msofficeforums.com/word/1...locations.html
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to make the slanted word editable by Word 2016?
    By london7871 in forum Word Formatting & General
    Replies: 4
    Last Post: 12-04-2017, 05:01 AM
  2. Replies: 1
    Last Post: 09-18-2017, 08:27 AM
  3. [SOLVED] custom menu through .xlam Addin visible but not working Office 2016
    By nigelog in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-15-2016, 12:29 PM
  4. [SOLVED] Word 2016 is default, but hyperlinks in Excel file open Word 2010
    By 6StringJazzer in forum Excel General
    Replies: 2
    Last Post: 11-29-2016, 11:29 PM
  5. Excel 2016 - Errors detected while saving
    By milo1984 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-18-2016, 05:49 PM
  6. Will it be a bug inside Word 2016 ?
    By neu_stone in forum Word Formatting & General
    Replies: 0
    Last Post: 09-29-2015, 11:49 AM
  7. [SOLVED] Can you convert a number to word equivalent ?
    By Nagesh K R in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-04-2005, 08:06 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1