View Single Post
  #36   Report Post  
Posted to microsoft.public.excel.newusers
JLatham JLatham is offline
external usenet poster
 
Posts: 3,365
Default Auto Number in Invoice

Pammi J,

Disregard the _Rev02 that you received today - contains 3 'show stopper'
errors in code. My apologies - that's what I get for trying to rush
something out the door without adequate testing. Have repaired the code,
will get working version to you this evening, along with suggestions for how
to set up your customer list for ease of data entry.

JLatham

"Pammi J" wrote:

Hi
hope someone can help me. I have an invoice i have designed and the last bit
i need before i use it is to assign a invoice number to the template and have
it automatically increase by one everytime - ie 101 would be 102 on opening
the next time.
i have read McGimpseys page and used the code - i put it in the this
workbook part but its not doing anything. Have i got the right code or do i
need any other bits to go with it? Also i dont understand what `text` file i
need - as its saying to create one? and what is default path as string - is
that where i type where my template is. Sorry im a newbie to invoice
numbering. but i only need this and then i can move on to other things.
many thanks