Is there a VBA code were i can print one worksheet multiple times and have a
file no. print in sequential order each time i print the worksheet.
ie. print 10 copies of the worksheet and the file no. will be 000001 -
000010. And the next time I print 10 copies the file no. will be 000011 -
000020.

Yes but there are some decisions to be made in terms of how to impliment the
sequential numbers. Check out this link...

http://www.mcgimpsey.com/excel/udfs/sequentialnums.html
--
HTH...

Jim Thomlinson


"BarryS" wrote:

Is there a VBA code were i can print one worksheet multiple times and have a
file no. print in sequential order each time i print the worksheet.
ie. print 10 copies of the worksheet and the file no. will be 000001 -
000010. And the next time I print 10 copies the file no. will be 000011 -
000020.

See Ron de Bruin's site for this.

http://www.rondebruin.nl/print.htm#same

Note the second set of code that allows for starting from where you left off.


Gord Dibben MS Excel MVP

On Thu, 22 Nov 2007 14:25:00 -0800, BarryS
wrote:

Is there a VBA code were i can print one worksheet multiple times and have a
file no. print in sequential order each time i print the worksheet.
ie. print 10 copies of the worksheet and the file no. will be 000001 -
000010. And the next time I print 10 copies the file no. will be 000011 -
000020.