PDA

View Full Version : Sleeper: Copy all workbook contents into a new one



crmpicco
05-17-2005, 03:12 AM
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

Bob Phillips
05-17-2005, 05:45 AM
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.

If you perform the steps manually with the macro recorder on, you will have a macro that does it.

crmpicco
05-17-2005, 06:43 AM
I have more than one sheet in my workbook that i want to copy, how do i select all content from all sheets?

johnske
05-17-2005, 06:56 AM
Hi crmpicco,

This sounds remarkably similar to the question in this (http://www.vbaexpress.com/forum/showthread.php?t=3246) thread - have a look at the code I put there and see if it's any help to you...

HTH
John

crmpicco
05-17-2005, 07:14 AM
is there a way i can do it without MANUALLY creating a new workbook? Is there code that will open Excel and create a new one for me???



Thanx

crmpicco
06-02-2005, 04:02 AM
anyone know how to do this?

Aaron Blood
06-02-2005, 05:19 AM
Although it might not be recognized as such... This question is asking how to bypass worksheet/workbook level security.

I could help you, but not on this forum.

crmpicco
06-02-2005, 06:19 AM
can you email me at crmpicco AT aol DOT com (crmpicco@aol.com)

crmpicco
06-02-2005, 06:21 AM
or even better IM me at crmpicco AT hotmail DOT com (crmpicco@hotmail.com)

crmpicco
06-02-2005, 08:49 AM
has anyone else got code?

crmpicco
06-02-2005, 08:53 AM
Due to the subject matter (password cracking), this thread has been closed.
Click here (http://www.vbaexpress.com/forum/faq.php?faq=psting_faq_item#faq_hack_faq_item) for more information regarding the VBAX posting rules.