Auto Number

[Atif Hasan]

Hi all
I am creating my invoices in Excel. I have created a template for the
invoices. There is one folder in which i save all my invoices with invoice
number which is in serial. is there any codeing that when i open my invoice
templete it automatically give me next invoice number that is saved in my
invoice folder (next to that number) and place it in my excel sheet cell.
thanks

 

[Jacob Skaria]

You need to use a macro to do this. Let us know the file name format.