• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

sending data to another page that is locked

Jack-P-Winner

Jack-P-Winner

Member
Is it possible to send data in a cell to another page if the cell is protected? If it is not protected? I want to be able to send information in columns WXYZ rows 01-3000. I also want them to count up

04 WXYZ
03 WXYZ
02 WXYZ
01 WXYZ

I want to send this data to a sheet called Game XXXX, Does this sheet have to be in the same book as the other?
 
Hi Jack,

Yes you can copy data from sheet whose cells are protected.

One thing to note is that you cannot copy it to a closed workbook. But you can open it through VBA paste the data, save it and close it back.

Below are codes to copy it to a different workbook and code to copy within same workbook. Change as appropriate.

Code: 
Sub CopyToOutsideFile()
Application.ScreenUpdating = False
Workbooks.Open "C:\temp 1.xlsx" ' Put the path of the file where it needs to be copied
ThisWorkbook.Sheets("sheet1").Range("w1:z3000").Copy ' change the sheet name to your source sheet name
Sheets("Game XXX").Range("a1").PasteSpecial xlAll 'It is being pasted in cell a1 of Game xxx sheet
ActiveWorkbook.Save
ActiveWorkbook.Close
ThisWorkbook.Activate
Application.ScreenUpdating = True
MsgBox Application.CountA(ThisWorkbook.Sheets("sheet1").Range("w1:w3000")) ' counts the number of rows copied
End Sub

Code: 
Sub CopyWithinFile()
Sheets("sheet1").Range("w1:z3000").Copy Sheets("Game XXX").Range("a1") 'Change the source sheet name as appropriate
MsgBox Application.CountA(Sheets("sheet1").Range("w1:w3000")) ' counts the number of rows copied
End Sub

Cheers,
BD
 
Do I copy each one of these to a separate sheet? Module? Can you please give me a step by step. I know some and learning more each and every day. Thank you so much BD

I am using Office 2013. I can go to Macros but mine are grayed out. I have had nothing but issues since I upgraded from 32 bit 2010 to 64 bit 2013. I can not seem to find where to place the module
 
Hi,

Below are the steps:

1: Open the file which has data that needs to be copied from.
2: Press Alt+F11. This will open up the VB Editor.
3: To the left hand side of the screen, you should be able to see the workbook name that is open and the sheets of the workbook and so on.
4: Right click on the work book name which should look like this - "VBA Project (filename)".
5: Select Insert --> Module
6: A new module should open up. Double click on it.
7: Paste the VB codes posted above.
8: Go back to excel. Press Alt+F4. You will get a list of available macros. Select the one you require and run it.

If you still find it difficult, post the file and we can help you with specific instructions.

Cheers,
BD
 
I will try as soon as I get home after lunch. Need to go to work for a little while. I have a new Toshiba windows 8 ): and I can not use the F keys sometimes but will try
 
This is the book I am trying to copy. Long story short. Microsoft installed a new version of office on my pc and now I can not get into MY OWN spreadsheets. I have been working with them since Wednesday to crack my excel so it can become un protected. No luck yet, another Guru will call me tomorrow afternoon. In the mean time I thought about this way if it will work I basically want to copy what I have in these books to another page so I can at least copy and paste. I do not need the code just the counter numbers (patterns) in STUV, AA, AB, AD and AE. This is one of 8 books I have so if I can get help with one I should be able to do the rest. It is large so may take a sec or two to open

https://www.dropbox.com/s/qxb2y0r3idif4b5/Stats COUNTERS 50+ Hit Numbers Book (3,000+).rar
 
BBD said:
Hi,

Below are the steps:

1: Open the file which has data that needs to be copied from.
2: Press Alt+F11. This will open up the VB Editor.
3: To the left hand side of the screen, you should be able to see the workbook name that is open and the sheets of the workbook and so on.
4: Right click on the work book name which should look like this - "VBA Project (filename)".
5: Select Insert --> Module
6: A new module should open up. Double click on it.
7: Paste the VB codes posted above.
8: Go back to excel. Press Alt+F4. You will get a list of available macros. Select the one you require and run it.

If you still find it difficult, post the file and we can help you with specific instructions.

Cheers,
BD
Click to expand...
I was afraid of that. I hit ALT F11 and it adjust my screen brightness. Got to love it LOL and my MACRO's are grayed out until I can crack my protected sheets that Microsoft protected by accident and cant unprotect UG
 
Jack,

we may be able to overcome the Macro protection by creating an independent workbook with the Macro, it will then Open the Source Book, copy the data, Open the Target Book and Paste the same data into the Target workbook.

cheers

kanti
 
Hi Jack,

I have no solution for you on this. Tried doing that in the file you have posted but with vain. You will have to get the file unprotected.

@kchiba
I tried doing that in the file which Jack has uploaded. It doesnt seem to paste data to the new workbook at all.
 
Now you see my frustration and their MY files. I'm the author, I own the software, it's registered, it's my lap top and I can't even get into my own files since the 2013 upgrade from Office 2010. That's why I thought about copying the info from this book than empty sheet. Now, the rows / columns are all unlocked off to the right and the Start sheets I've managed to Unprotect
 
Hi Jack,

Attached is a file that I use to copy data from Closed files to Closed files.

You give the name of the Source File, The sheet name and range and the same for the target.

try it out

cheers

kanti
 

Attachments

  • Data_extractor_Range.xlsm
    29.2 KB · Views: 7
Th
kchiba said:
Hi Jack,

Attached is a file that I use to copy data from Closed files to Closed files.

You give the name of the Source File, The sheet name and range and the same for the target.

try it out

cheers

kanti
Click to expand...
Thanks I will try this out this morning after I wake up and have a cup of java lol
 
Jack-P-Winner said:
Long story short. Microsoft installed a new version of office on my pc and now I can not get into MY OWN spreadsheets. I have been working with them since Wednesday to crack my excel so it can become un protected.
Click to expand...
Hi, Jack-P-Winner!
Without any further intention but help, are you sure that it wouldn't be easy, cheaper and faster to buy a commercial software alternative like those from Elcomsoft? Unless that you're not hurried at all and 4 working days (till now) of yours don't value 50-250 bucks, regarding the desired version.
Regards!
 
SirJB7 said:
Hi, Jack-P-Winner!
Without any further intention but help, are you sure that it wouldn't be easy, cheaper and faster to buy a commercial software alternative like those from Elcomsoft? Unless that you're not hurried at all and 4 working days (till now) of yours don't value 50-250 bucks, regarding the desired version.
Regards!
Click to expand...
Hi sir,

I spent downloaded Elcomsoft and let it run for two days. It sid my sheet was now unprotected but it was not. I have tried at east 5 other removers and all come up as a fail. Starx was the ONLY one that gave me 2 out of 4 of my passwords backbut I am only able to open 20% of my files. I am in a hurry. Microsoft calls again this afternoon at 4
 
Hi, Jack-P-Winner!

Any chance that you can upload that workbook only?

Besides, which product from Elcomsoft have you downloaded, AOPR or AOPB (Advanced Office Password Recovery or Breaker), and what version of it are you using (Home, Standard or Professional, for AOPR; Standard, Professional or Enterprise, for AOPB)?
Regarding the versions difference, please check this to find out which one better applies to your case:
http://www.elcomsoft.com/aopr.html#chart
http://www.elcomsoft.com/aopb.html#chart
For AOPR if the main issue is the VBA project pwd, check the last item in the comparison table (you'd have to go for the Professional); otherwise for Excel only, the Standard will be enough).
For AOPB check the last 2 items in the comparison table (your only choice will be the Enterprise).

Despite of this, the related file, what type of Excel file is it? .xls, .xlsm, .xlsb, ...

Regards!
 
SirJB7 said:
Any chance that you can upload that workbook only?

Besides, which product from Elcomsoft have you downloaded, AOPR or AOPB (Advanced Office Password Recovery or Breaker), and what version of it are you using (Home, Standard or Professional, for AOPR; Standard, Professional or Enterprise, for AOPB)?
Regarding the versions difference, please check this to find out which one better applies to your case:
http://www.elcomsoft.com/aopr.html#chart
http://www.elcomsoft.com/aopb.html#chart
For AOPR if the main issue is the VBA project pwd, check the last item in the comparison table (you'd have to go for the Professional); otherwise for Excel only, the Standard will be enough).
For AOPB check the last 2 items in the comparison table (your only choice will be the Enterprise).

Despite of this, the related file, what type of Excel file is it? .xls, .xlsm, .xlsb, ...
Click to expand...
Hi!
Still pending to be answered.
Regards!
 
Sorry sir, I've been extremely busy with our Cafe this time of year in the USA with all the holidays and all. I'm on my iPad but will address your questions when I can this evening I spent an hour with Microsoft yesterday , sent them one if my books for them to crack. There calling me back today with the answer My books are too large to zip and email. I can only send them via drop box using a link to down load

Are you a distributor for Elmcosoft? You seem to be pushing that one so what's up? Lol
 
Hi, Jack-P-Winner!
If I were involved commercially with Elcomsoft I've already had told you to buy the AOPR Professional and AOPB Entreprise editions, despite of having offered my services for the bargain sum of 500 U$S per hour. But I'm just a contributor at chandoo.org.
Regards!
 

Distributor for Elmcosoft, SirJB7 ?! Gosh nope !

I thought he was for … Of course it's a secret !
But after his famous mission in Danmark, I had this code (I used to work in cryptography) :​

Code: 
Sub Distributor()
  AR = [{"a","b","C","e","g","l","r","s"}]
  For Each C In Split("3 1 7 6 8 2 4 7 5"):  T$ = T$ & AR(C):  Next
  MsgBox T & " !", , "Distributor for …"
End Sub

3d-irlandais-3.gif
Prosit !​
 
Last edited:

I had it via an ex-agent of famous french team Rainbow Warrior from a Rusky at Gorki Park !
I wasn't activated, just a cypher analyst …

ReCarlsGardsBerg too !
​
 
Lol, I'm
SirJB7 said:
Hi, Jack-P-Winner!
If I were involved commercially with Elcomsoft I've already had told you to buy the AOPR Professional and AOPB Entreprise editions, despite of having offered my services for the bargain sum of 500 U$S per hour. But I'm just a contributor at chandoo.org.
Regards!
Click to expand...


kidding with you sir. (-:
 
You must log in or register to reply here.
Back
Top