Copy workbook contents into new one

		Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
Copy workbook contents into new one

Excel VBA Discuss using VBA for Excel programming.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

May 17th, 2005, 05:10 AM

crmpicco

Friend of Wrox

Join Date: Jan 2005

Posts: 1,525

Thanks: 0

Thanked 0 Times in 0 Posts

Copy workbook contents into new one

I am looking for code that will copy all contents of a Workbook. Open a new workbook, then paste all the cells into the new workbook.

The reason for me having to this is because the original workbook is protected and I cannot write to it.

Is there a way to do this automatically?

Thanks.

Picco

www.crmpicco.co.uk
www.crmpicco.co.uk.tt
www.milklemonadechocolate.uk.tt
www.griswolds.uk.tt
www.piccosmini.co.uk.tt
www.morton.uk.tt

__________________
_______________________
Ayrshire Minis - a Mini E-Community
http://www.ayrshireminis.com
http://www.crmpicco.co.uk

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Copy worksheet to another workbook and rename it	Probleminfinity	Excel VBA	1	August 19th, 2007 11:38 PM
Copy Worksheet into another workbook	money	Excel VBA	4	March 8th, 2007 05:17 AM
Copy all contents except current node in XSLT	2BOrNot2B	XSLT	2	December 19th, 2006 06:44 PM
Copy contents of Word doc & Paste in Excel - How??	robear	Javascript How-To	1	August 23rd, 2006 03:22 PM
Copy a worksheet range to a new workbook	cej2583	Excel VBA	2	March 14th, 2006 11:55 PM