Ed,

When I look at that page I see a funtion called "NextSeqNumber," which is
different than the name you use below. Is it possible that you are calling
the function by the wrong name?

hth,

Doug

"Ed" wrote in message
...
I'm trying to generate a sequential number. I have a workbook ( .xls)
used
as a "template" to create new order forms. Each form must have a
sequential
number. The number is generated and inserted into the proper cell, then
the
workbook is SavedAs with the sequential number as part of the new file
name.
(I was trying to use an incremented CustomDocumentProperty when I finally
realized the incremented number got saved with the new file, while the
original number stayed with the original "template" file!)

I copied the text file macro (from
http://www.mcgimpsey.com/excel*/udfs...ntialnums.html) into the same
module I have all the other macros for this workbook, and inserted the
calling line
ThisWorkbook.Sheets(1).Range("B2").Value = GetNextSeqNumber
in the macro that inserts the new sequential number.

When stepping through this, the code runs right over that line, and
GetNextSeqNumber stays empty. The code never steps into the function to
generate the next number, and the text file that is supposed to hold the
number is never generated (it does not exist now).

What am I doing wrong?

Ed