dim myFileName as string
myfilename = "c:\yourpathhere\" & "FNE" _
& format(worksheets("balance").range("C5").value, "dd_mm_yyyy") _
& ".xls"

activeworkbook.saveas filename:=myfilename, fileformat:=xlworkbooknormal

XCESIV wrote:

I would like something very similar.

I would like it to save using the date of the wages fortnight.

I would like mine to save with "FNE " then the date like in the eg
which is in cell named "PAY_PERIOD" which is C5 in Balance sheet.
eg
"FNE 07_03_05.xls"
"FNE 07_17_05.xls"
"FNE 07_31_05.xls"

--
XCESIV
------------------------------------------------------------------------
XCESIV's Profile: http://www.excelforum.com/member.php...o&userid=24271
View this thread: http://www.excelforum.com/showthread...hreadid=538238

--

Dave Peterson