Thread: [Solved] Numbering labels prints
View Single Post
 
Old 11-29-2013, 07:04 PM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Hi Valeria,

Try the attached copy of your 'ex1 label' document. What I've done is to move all your content into the page header. At the moment, it's just a proof-of-concept demo, based on the code from: https://www.msofficeforums.com/word-vba/12959-sequential-document-numbering.html#post34477

If the approach taken meets your needs, we can modify the code with your macro wording, etc, then add just the code to a template that you could attach to all your documents so that they wouldn't need to each have the same code and could be saved as .docx files.

If you examine the code, you'll see there are some lines commented-out. For production use, those lines could be made active so that, amongst other things, the printout happens automatically - a different approach could be taken to work through the print dialogue if you prefer. The commented-out line to update the page # means that, next time the document is opened, the starting number would always be one more than the finishing number from the time before.
Attached Files
File Type: zip ex1 label.zip (41.9 KB, 16 views)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote