Using a text file to hold sequential numbers

Hi All
i found a macro that im trying to get working from the site below to generate a number everytime my template is opened.

ive put the code in the thisworkbook module as directed and changed the relevant path but it doesnt do anything i think im missing something but cant see what.
any help would be appreciated
this is the code ive placed in thisworkbook module of my template

Please Login or Register  to view this content.

ive also placed the code below in in a macro

Please Login or Register  to view this content.

the original code came from

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

thanks

Hi Leith

no theres no error generated
the cell value was 000000019 which was entered manually ive also tried it with the cell value blank

have i placed the code in the corredct places?

Hi Royuk

Bit overcomplicated,are you using a *.xlt workbook?

yes its an axcel template file .xlt

to be honest im pretty new to this so i dont know how it does it (or doesnt in this case)

is there an easier way?

thanks

i did get the registry version working but, i need to put the workbook on another machine thats why i wanted to use the text file version,

the template is going to be on a shared drive so every time its opened it creates a new file and saves it.

ive attached the file
thanks

Thanks for all the help guys
leith the above code did the trick

Excellent!