http://support.microsoft.com/default...b;en-us;165639

here is a link to how to count files in a directory

"Josh" wrote:

Hi,

I'm working on a price quotation template and I need some help. There is a
cell call it F4 that has the quotation reference number in it. What I want
to do is create a marco that runs when the template is opened that
automatically inserts concatenated data that is the 'system date' & "-" &
(here's the kicker) the count of the number of files in a given folder plus 1
in a ### format. For instance, take today and there are 10 quotes in the
folder, the cell would display "38387-011".

Is this possible, and if so how?

Sincerely,

Josh Hallenbeck