Grab this file, hope you have WinZip or something able to open .zip files,
and extract both files in it TO THE SAME FOLDER. The two files, one .txt and
one .xls, must be in the same folder for some features to work.

This will show how it can be done, and I've added lots of comments so
hopefully you'll be able to customize it yourself. If not, ask questions
here or via email and I'll try my best to answer.

In previous book, I misinterpreted what you'd tried and thought there was a
name of some type in E5, not that it was where the invoice number was to be
placed. This fixes that. It's NOT 100% automatic - it is an on-demand
function via macro that grabs a value from the .txt file, increments it by
one and stuffs it into E5 and then also saves that number back to the .txt
file so that the next time you use the macro, whether in that workbook or
another, you'll get the next sequential invoice number. This is all based on
McGimpsey's sample work.

What I've done with it to modify it is to take away the need to define a
default path to the .txt file, although you may do that also, and may want
to. But if no default path is provided, then it gets the .xls file's path
and uses that to go find the InvoiceNumber.txt file - and that's why both
files need to be in the same folder.

http://www.jlathamsite.com/uploads/for_PammiJ.zip
if you get a security alert about a .zip file and aren't permitted to upload
it, try right-clicking the link and using Save Target As.


"Pammi J" wrote:

Thats exactly what im after Lizard1socal - exactly what that template does
with the invoice number - unfortunatly i cant get into it - its asking for a
password

"lizard1socal" wrote:

JLatham,
Appreciate the reply, although as a simple user didnt understand it
all , but got the jest of what you wrote.
My next question is that , in Excel there is a business invoice
template that has the area for the invoice number, and shows a number in the
template. Now if the template has and shows the number, isnt there someway to
activate that cell with an auto number formula ? ( a new users
question,basically ignorant here )
Thx for your help, undrstanding and patience with us of lessor
knowledge !
LIZARD1SOCAL