Global macro across a number of different word files
It took a while but I worked it out (after reading/researching your site and others). Currently our staff print serial number labels (60mm x 15mm) that contain the number and a barcode above it then stick these onto a Word generated document. This is very tedious and time consuming. I created a macro where we can now edit the document and the macro is embedded within a shortcut (I used a print symbol in the quick access toolbar). When the user completes the editing, the macro asks the user to input the number of copies required and the starting serial number. The document has the printed sequential serial number with the barcode in sequence.
I do have a question I cannot figure out and have not implemented the above feature to staff yet. We have about 100 or so different documents that require the above process. The serial/barcode location is in exactly the same location on every document (Top right-hand corner in the header section). I want to avoid putting this macro on every document. I would like the user to open any of those documents located on a specific subfolder on the work network. When they hit the 'print' icon (macro shortcut) the input prompts begin. I'm guessing the macro need to reside in that subfolder but not sure how to tackle this issue. I tried looking through global macros across different PCs but could not work it out. Please help. I'm using 2013 but some machines are using 98 and 2007 adn would need it backward compatible if at all possible.
|