copy sheets to closed workbook

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Takeadoe - 06 Jul 2007 16:35 GMT

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

Reply to this Message

Bob I - 06 Jul 2007 17:13 GMT

Sending them TO a closed file? That would be a bit of a problem for the
file to get bigger without being open.

> Good morning -
>
[quoted text clipped - 6 lines]
>
> Mike

Reply to this Message

Takeadoe - 06 Jul 2007 17:36 GMT

Bob - Implicit in that the files are being opened, saved, and closed
with a script and be transparent to the user.

Sorry.

> Sending them TO a closed file? That would be a bit of a problem for the
> file to get bigger without being open.
[quoted text clipped - 11 lines]
>
> - Show quoted text -

Reply to this Message

Bob I - 06 Jul 2007 18:08 GMT

Any reason to not just Record a Macro that does this?
Open target Workbook, Select Source Worksheet, Edit, Move or Copy
Sheet.........

> Bob - Implicit in that the files are being opened, saved, and closed
> with a script and be transparent to the user.
[quoted text clipped - 16 lines]
>>
>>- Show quoted text -

Reply to this Message

Takeadoe - 09 Jul 2007 12:43 GMT

Bob I,

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

Thanks for your time and help!

Mike

> Any reason to not just Record a Macro that does this?
> Open target Workbook, Select Source Worksheet, Edit, Move or Copy
[quoted text clipped - 22 lines]
>
> - Show quoted text -

Reply to this Message

Bob I - 09 Jul 2007 18:26 GMT

You're welcome, we all learn it somewhere!

> Bob I,
>
[quoted text clipped - 31 lines]
>>
>>- Show quoted text -

Reply to this Message

Dave Peterson - 06 Jul 2007 18:02 GMT

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.

> Good morning -
>
[quoted text clipped - 6 lines]
>
> Mike

Signature

Dave Peterson

Reply to this Message

Takeadoe - 09 Jul 2007 12:42 GMT

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
[quoted text clipped - 26 lines]
>
> Dave Peterson

Reply to this Message