Print template with changing numbering

**Anar** · 11-25-2011, 03:33 AM

Hi, guys,

I need help. The issue is that I have a template, I need to print 120 copies of it. The whole structure of the template does not change except for the numbers of the each template, for example, first printed template should have a number QSA1, second QSA2, etc.
It can be done manually, however changing numbers in each template and printing them will take a lot of time.

Thank you

**Marcus Ahlbäck** · 11-25-2011, 04:18 AM

Hi

If the the template is just 1 page you maybe could use page numbering?

**JieJenn** · 11-25-2011, 04:20 AM

Can u attach a sample file?

**royUK** · 11-25-2011, 05:09 AM

It can be done with VBA

Please Login or Register  to view this content.

**Anar** · 11-25-2011, 07:06 AM

Thank you, all
Especially royUK, your code works well.
Could you just add one more line for option to select number of copies, for example, 10 instead of 120

**royUK** · 11-25-2011, 07:29 AM

Here's a similar example that you could adapt

**Anar** · 11-25-2011, 07:43 AM

royUK, thank you for example.
I prefer using your new code.
How can I add prompt option (inputbox) for both first and last numbers of iX in the code?

**royUK** · 11-27-2011, 03:49 AM

Try this

Please Login or Register  to view this content.

**Anar** · 11-28-2011, 02:11 AM

Thank you , a lot, royUK

You are genious.

**royUK** · 11-28-2011, 02:24 AM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save