Does XL have a built-in method that I could tap into to autosequence my
filenames when saving?

I have a template that uses a couple parameters to come up with a
filename, ie Job# JobType.xls. Since several files with the same Job#
& JobType in a day is not uncommon, simply adding a date string won't
work. What I've been doing is manually adding an increment number, ie
Job# JobType1.xls, Job# JobType2.xls

I need to come up with a macro during FileSave to count every file in a
directory that matches the new intended file and append that count to
the end of the new file name.

TIA

Andy


--
AH·C
------------------------------------------------------------------------
AH·C's Profile: http://www.excelforum.com/member.php...o&userid=29108
View this thread: http://www.excelforum.com/showthread...hreadid=488537