Hi Nico,
Try saving the file by using the Save method before closing it. Add
this line of code right before the ActiveWorkbook.Close...statement:
ActiveWorkbook.Save
Hope this helps,
theDude
--
theDude
------------------------------------------------------------------------
theDude's Profile:
http://www.excelforum.com/member.php...o&userid=16550
View this thread:
http://www.excelforum.com/showthread...hreadid=375007