Copy from Excel list to Word

[meakashgfx]

Hi,
I need help to make a VBA. I want to print some serial number on a pre-printed sticker.

I have the following files:
SerialNumber.xls (100k Random Number in A1-A100000)
PrintableFormate.doc (Black Document)


I want to create VBA in .doc file. When I will open that file, input box will ask me how many number i want to get from excel (It should not be in that list after done copy/cut). then It will paste one by one.


Any idea? help me if any part of this action you can.


Thanks in advance!

[MacroWizard]

Meakashgfx,

Do you need the number to be randomly chosen?

[meakashgfx]

no! if inputbox value = 100 then it will cut cell A1:A100

thanks Macro wizard for your response.