Automatic Quote Numbering

[Roni]

Hello,

I am looking to develop a sales quote template that automaticall
updates each time I open the file and create a new quote by INCREASIN
the quote number by 1. For example, if the last quote I wrote is #233
the next time I open the file, it should be #234 automatically, and th
next time #235 etc.

Can I do this is Word or Excel? If so, can you please clearly explai
how?

Thanks

 

[Anne Troy]

Excel: http://www.vbaexpress.com/kb/getarticle.php?kb_id=348
Word: http://www.vbaexpress.com/kb/getarticle.php?kb_id=56

*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com

 

[Roni]

Thanks Anne. Unfortunately I am not able to get this to work wit
Microsoft Word. For the location of the .txt file, is this the blan
one that I am supposed to save? How come in the attachement (sample
the txt file is not blank?

Any clarification?

Thanks,

Sharon