In addition, you can replace these two lines

ActiveWorkbook.Saved = True
ActiveWorkbook.Close

with the much cleaner

ActiveWorkbook.Close SaveChanges:=False

--
Regards,
Tom Ogilvy

"Leith Ross" wrote
in message ...

Hello NIck,

Looks like a typo. You forgot tp put the colon after filename.

FileName:="\\Fiesta\Wg_memb_sec\Community Dividend\New
Payments\Admin\Chq details\CommDiviChqs.csv", _


Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile:
http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=479170