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.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.