Hi

I need to save the worksheet(VG) which exist in workbook(A) to th
workbook named (Cot) which is located in My Document Folder:

once the Cot workbook is closed
once the Cot workbook is opened

:( :( :(

NB: I know how to save the mentioned sheet to a new workboo

--
helmekk

-----------------------------------------------------------------------
helmekki's Profile: http://www.excelforum.com/member.php...nfo&userid=693
View this thread: http://www.excelforum.com/showthread.php?threadid=27219