I am trying to creat an invoice template using Excel 2002. My purpose is to
auto increment the invoice number whenever I make a new invoice.

Take a look he

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



In article ,
"Hiren" wrote:

I am trying to creat an invoice template using Excel 2002. My purpose is to
auto increment the invoice number whenever I make a new invoice.

Hello JE McGimpsey,

Thanks for the instant help. However whenever the workbook template is
accessed for a new invoice generation, it give a runtime error which when
debugged points to
With ThisWorkbook.Sheets("Invoice")
line of the code. I m not sure if I m doing it correct as I dont use macros
regularly but this code has been saved in ThisWorkbook window, under open
event. Is this OK?

"JE McGimpsey" wrote:

Take a look he

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



In article ,
"Hiren" wrote:

I am trying to creat an invoice template using Excel 2002. My purpose is to
auto increment the invoice number whenever I make a new invoice.

The location is OK. Change the sheet name to your worksheet.

In article ,
"Hiren" wrote:

Thanks for the instant help. However whenever the workbook template is
accessed for a new invoice generation, it give a runtime error which when
debugged points to
With ThisWorkbook.Sheets("Invoice")
line of the code. I m not sure if I m doing it correct as I dont use macros
regularly but this code has been saved in ThisWorkbook window, under open
event. Is this OK?

Thanks. It does work now.

Is there a book I can purchase and test some sample macros which maybe
useful for my other functions in the invoice?

Rgds,


"JE McGimpsey" wrote:

The location is OK. Change the sheet name to your worksheet.

In article ,
"Hiren" wrote:

Thanks for the instant help. However whenever the workbook template is
accessed for a new invoice generation, it give a runtime error which when
debugged points to
With ThisWorkbook.Sheets("Invoice")
line of the code. I m not sure if I m doing it correct as I dont use macros
regularly but this code has been saved in ThisWorkbook window, under open
event. Is this OK?

One way would be to put it in the before print event of the ThisWorkbook
module.

--
Don Guillett
SalesAid Software

"Hiren" wrote in message
...
I am trying to creat an invoice template using Excel 2002. My purpose is
to
auto increment the invoice number whenever I make a new invoice.

Hi Hiren

if you'ld like to email me direct (julied_ng at hcts dot net dot au) i
have a sample invoicing workbook which you might be able to customise to
your needs or get some ideas from etc.

alternatively (or as well) check out
http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

Cheers
JulieD

"Hiren" wrote in message
...
I am trying to creat an invoice template using Excel 2002. My purpose is to
auto increment the invoice number whenever I make a new invoice.

Hiren, have a look here for how to do it

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


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003


"Hiren" wrote in message
...
I am trying to creat an invoice template using Excel 2002. My purpose is to
auto increment the invoice number whenever I make a new invoice.