Does Workbook need to be open to copy to..from vba

  • Thread starter Thread starter Dale
  • Start date Start date
D

Dale

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Similar Book to Book Code, one works other does not 11
VBA code for pasting links -- modifying RDB code for summary workbook 10
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Closing running sub from a different one 3
Copying Sheets to a woekbook 1
Copying cells and formula from closed workbook to all sheets in open workbook 0
Excel Move or Copy Stopped Working? 0
Scattered array cells copy to scattered array cells another workbook 14

Back
Top