Which method did you choose for storing the number?

Registry or *.txt file?

Did you also place the

Public Sub Workbook_Open()
ThisWorkbook.Sheets(1).Range("B2").Value = NextSeqNumber
End Sub

in Thisworkbook module?


Gord Dibben MS Excel MVP

On Fri, 11 Jul 2008 16:51:01 -0700, Jeff W
wrote:

Thanks for the quick response Mike. I have copied the syntax exactly as was
on the website, but I am not getting am invoice number when I open a new
document using the template. I would like for the number to appear on the
document itself. (In cell B2 to be exact). Any idea what am I doing wrong?