Glad you got it to work!

Shockley


"Linc" wrote in message
...

Thanks for the response. I ultimately figured out that the string I
needed was

Activeworkbook.SaveAs "NameofFile_" & Cells(1, 12)

This added the counter number to the name of the file and saved it. So
the file Incidnet.xls became Incident_1002.xls with 1002 coming from
the cell in row one column 12.

Thanks for your help too.

Linc


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/