Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Invoice template auto number

9 views
Skip to first unread message

André Lachapelle

unread,
Aug 14, 2002, 9:33:07 PM8/14/02
to
Hello,

I make an invoice template but now I would like to know how I can make
the Invoice Number to be increment automaticaly when I open my template...

André, Thank's for anyone help...


Vasant Nanavati

unread,
Aug 14, 2002, 10:01:05 PM8/14/02
to
Hi Andre:

Put this macro in the ThisWorkbook code module:

Private Sub Workbook_Open()
Range("A1") = Range("A1") + 1 'or wherever the invoice no. is
End Sub

I assume you are using the term "template" generically and that this is
not a real template with an XLT extension. If it is, you would store the
most recent invoice number in the Windows Registry using the SaveSetting
statement.
--
Regards,

Vasant.

**No direct emails please--keep discussion in newsgroup.**


"André Lachapelle" <andre.la...@videotron.ca> wrote in message
news:IED69.21302$gY3.5...@weber.videotron.net...

0 new messages