save Wsh to closed/opened WB
 

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

save Wsh to closed/opened WB
 

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
|