Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Does Workbook need to be open to copy to..from vba
I recieve monthly financial summaries by dept in one workbook where each tab
is a dept. I want to distribute to each department by copying each worksheet to an existing workbook that has been created for that dept...at the end of the year there will be 12 tabs/wkbook each named by month. Does the "destination" workbook have to be open or can I copy a worksheet to it by vba...I see examples of getting code to a closed workbook, but not sending to a closed workbook. TIA Excel 2000 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Does Workbook need to be open to copy to..from vba
Darn..that should have said, I've seen code examples of getting data FROM a
closed workbook, but not SENDING a worksheet to a closed workbook "Dale" wrote in message ... I recieve monthly financial summaries by dept in one workbook where each tab is a dept. I want to distribute to each department by copying each worksheet to an existing workbook that has been created for that dept...at the end of the year there will be 12 tabs/wkbook each named by month. Does the "destination" workbook have to be open or can I copy a worksheet to it by vba...I see examples of getting code to a closed workbook, but not sending to a closed workbook. TIA Excel 2000 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Worksheet from one open workbook to another... | Excel Worksheet Functions | |||
Macro to close workbook and re-open new copy | Excel Discussion (Misc queries) | |||
Open and copy all workbook sheets in a folder to a master file | Excel Discussion (Misc queries) | |||
Copy worksheet from Active workbook into all other open workbooks | Excel Programming | |||
copy sheet1 from all open workbooks to one workbook | Excel Programming |