Andy, how about adding a data and TIME to the file name, something like

ActiveWorkbook.SaveAs Filename:="Your Parameters Here" & Format(Now,
"mm-dd-yyyy-hh-mm") & ".xls", FileFormat:= _
xlNormal, Password:="", WriteResPassword:="",
ReadOnlyRecommended:=False _
, CreateBackup:=False
End Sub


--
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

"AH·C" wrote in message
...

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