You must open Cot. No way around that. Then copy the sheet, save and close
Cot.

--
Jim Rech
Excel MVP
"helmekki" wrote in message
...
|
| Hi
|
| I need to save the worksheet(VG) which exist in workbook(A) to the
| 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 workbook
|
|
| --
| helmekki
|
|
| ------------------------------------------------------------------------
| helmekki's Profile:
http://www.excelforum.com/member.php...fo&userid=6939
| View this thread: http://www.excelforum.com/showthread...hreadid=272193
|