save Wsh to closed/opened WB

[helmekki]

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

 

[Jim Rech]

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

--
Jim Rech
Excel MVP
|
| 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?action=getinfo&userid=6939
| View this thread: http://www.excelforum.com/showthread.php?threadid=272193
|