copy sheets to closed workbook

  • Thread starter Thread starter Takeadoe
  • Start date Start date
T

Takeadoe

Good morning -

I've found countless examles (e.g. http://www.rondebruin.nl/tips.htm)
on how to extract data from a closed workbook. I'm trying to select a
group of worksheets and send them to a closed workbook. Can anyone
point me to an example?

Thanks in advance!

Mike
 
Sending them TO a closed file? That would be a bit of a problem for the
file to get bigger without being open.
 
Bob - Implicit in that the files are being opened, saved, and closed
with a script and be transparent to the user.

Sorry.
 
Start by recording a macro when open the receiving workbook, back to the
original workbook, select the worksheets, and edit|move or copy sheets to the
newly opened workbook.

Then close and save the receiving workbook.

If you wrap your code with:

sub macronamehere()
application.screenupdating = false
your recorded code here
application.screenupdating = true
end sub

It may even work the way you want with not much tweaking.
 
Any reason to not just Record a Macro that does this?
Open target Workbook, Select Source Worksheet, Edit, Move or Copy
Sheet.........
 
Thank you Dave. I got 'er done!

Mike


Start by recording a macro when open the receiving workbook, back to the
original workbook, select the worksheets, and edit|move or copy sheets to the
newly opened workbook.

Then close and save the receiving workbook.

If you wrap your code with:

sub macronamehere()
application.screenupdating = false
your recorded code here
application.screenupdating = true
end sub

It may even work the way you want with not much tweaking.
Click to expand...
 
Bob I,

Very good question! I guess because I just don't do enough of this
stuff.

Thanks for your time and help!

Mike
 
You're welcome, we all learn it somewhere!
Bob I,

Very good question! I guess because I just don't do enough of this
stuff.

Thanks for your time and help!

Mike
Click to expand...
 
Back
Top