I have the following code

Sub SaveAsCSV()
ActiveWorkbook.SaveAs Filename = "\\Fiesta\Wg_memb_sec\Community
Dividend\New Payments\Admin\Chq details\CommDiviChqs.csv", _
FileFormat:=xlCSVWindows, CreateBackup:=False
ActiveWorkbook.Saved = True
ActiveWorkbook.Close

End Sub

When I run the code, the file is saved in the right location but with
the name False.csv.

Can anybody help please.

Thanks in advance

Nick


--
Nick S
------------------------------------------------------------------------
Nick S's Profile: http://www.excelforum.com/member.php...o&userid=16512
View this thread: http://www.excelforum.com/showthread...hreadid=479170