+ Reply to Thread
Results 1 to 7 of 7

Unprotect workbooks Encrypting and Decrypting workbook security when opens

  1. #1
    Forum Contributor
    Join Date
    08-12-2010
    Location
    Excel World
    MS-Off Ver
    Excel 2010 & 2007
    Posts
    210

    Question Unprotect workbooks Encrypting and Decrypting workbook security when opens

    Hi All,

    I have four different workbooks which are encrypted (protected security) with different passwords. so everytime I have to put the right password for accessing any one of them (Password to Open).

    Workbook Kingdom1 has password ›—› a123
    Workbook Kingdom2 has password ›—› b123
    Workbook Kingdom3 has password ›—› c123
    Workbook Kingdom4 has password ›—› d123

    I have written some codes in a module to perform actions in the workbook - Kingdom1's Sheet1. Then I want to copy the data from Kingdom1 worksheet to the rest of the three workbook (on the Sheet1).

    I would like to run the codes from the 1st workbook - Kingdom1

    1) How can I automatically open above encrypted workbooks? so that I don't even have to enter password for accessing the other workbooks.
    2) How can I paste the data from Kingdom1 workbook's Sheet1 to the other workbooks Sheet1? (If the data lies from just below to the top header row to the 50th row in the workbook Kingdom1' Sheet1, so that should be copied and pasted in the other workbooks.)
    3) After copying and pasting data from one to another workbooks, how can I save & close the rest of the workbook?
    4) At first, while running the codes, how can I ensure that the rest of the workbooks are closed? so the macro will not be stucked.

    P.S. ›—› All the four workbooks are in different folders(different location in the drive).

    I am sure that someone will come up with solution & help me.

    In MS Excel 2003: Tools >Options >Security >Password to Open
    In MS Excel 2007: On the top left side (on the MS Office icon) >Prepare >Encrypt Document

    Thanks in advance!
    Last edited by SunOffice; 05-07-2011 at 12:19 AM.
    Excelforum is Completely Awesome! True learning with Live Examples & Best Techniques!!

  2. #2
    Forum Expert Simon Lloyd's Avatar
    Join Date
    03-02-2004
    Location
    locked in the cage
    MS-Off Ver
    All the ones my homepage shows
    Posts
    3,161

    Re: Unprotect workbooks Encrypting and Decrypting workbook security when opens

    It would help a great deal to see the macro's taht you are running as they should not affect an open workbook other than the one they are in. The following macro (untested) assumes that all the workbooks (except Kingdom1) are in the same folder on their own.
    Please Login or Register  to view this content.
    Not all forums are the same - seek and you shall find

  3. #3
    Forum Expert Simon Lloyd's Avatar
    Join Date
    03-02-2004
    Location
    locked in the cage
    MS-Off Ver
    All the ones my homepage shows
    Posts
    3,161

    Re: Unprotect workbooks Encrypting and Decrypting workbook security when opens

    Sorry, i'll have to re think this, it's an old macro rehashed, Filesearch isn't supported anymore after xl2003. it's 4:45am here so it may be a little later when i get up before ican give you another solution.

  4. #4
    Forum Contributor
    Join Date
    08-12-2010
    Location
    Excel World
    MS-Off Ver
    Excel 2010 & 2007
    Posts
    210

    Re: Unprotect workbooks Encrypting and Decrypting workbook security when opens

    Thanks for ur reply!
    I forgot to mention in the thread - All the four workbooks are in different folders(different location in the drive).

  5. #5
    Forum Expert Simon Lloyd's Avatar
    Join Date
    03-02-2004
    Location
    locked in the cage
    MS-Off Ver
    All the ones my homepage shows
    Posts
    3,161

    Re: Unprotect workbooks Encrypting and Decrypting workbook security when opens

    well in that case you need to:
    1. give all the locations (drive paths)
    2. give the range that should be copied
    3. give the destination range
    4. state whether the workbook running the code is either none of those workbooks or one of them
    5. are any of the sheets in any of the workbooks protected

  6. #6
    Forum Contributor
    Join Date
    08-12-2010
    Location
    Excel World
    MS-Off Ver
    Excel 2010 & 2007
    Posts
    210

    Re: Unprotect workbooks Encrypting and Decrypting workbook security when opens

    Plz see the attached, you can see in it: I have made four encrypted workbooks, and the 1st workbook contains data, which is filtered by codes and get pasted in a new worksheet("GetDATA"), And I want to send this data from Kingdom1 workbook to another three workbooks.

    Now I hope you can visualize the real situation. Please let me know if u need anything more for the same.
    Attached Files Attached Files
    Last edited by SunOffice; 05-07-2011 at 05:58 AM.

  7. #7
    Forum Contributor
    Join Date
    08-12-2010
    Location
    Excel World
    MS-Off Ver
    Excel 2010 & 2007
    Posts
    210

    Re: Unprotect workbooks Encrypting and Decrypting workbook security when opens

    For the solution, I have written all the below codes for required actions, plz look at them:

    Please Login or Register  to view this content.
    and

    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    All these codes are working fine for me, and this is what I was looking at, but I'm still getting one serious issues Before copying and pasting the data from one to rest of the workbooks or running the codes, How can I be ensure that all the other workbooks are closed and unshared? so the job will be done successfully!

    I have codes in the workbook 'Kingdom1', and would like to run the codes from here to know about the other workbooks if they are not closed by the users and unshared. Then perform the above codes.


    I hope somebody will come up with his/her great idea for the above problem!
    I would appreciate if some verify my codes and tries to improve them.

    Plz checkout the attached.
    Attached Files Attached Files
    Last edited by SunOffice; 05-07-2011 at 03:35 PM. Reason: Added attachment.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

X vBulletin 4.1.8 Debug Information

  • Page Generation 1.17308 seconds
  • Memory Usage 9,026KB
  • Queries Executed 15 (?)
More Information
Template Usage (33):
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_global_above_footer
  • (1)ad_global_below_navbar
  • (1)ad_global_header1
  • (1)ad_global_header2
  • (1)ad_navbar_below
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)ad_thread_first_post_content
  • (1)ad_thread_last_post_content
  • (4)bbcode_code
  • (1)footer
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)headinclude_bottom
  • (7)memberaction_dropdown
  • (1)navbar
  • (4)navbar_link
  • (4)navbar_noticebit
  • (6)option
  • (2)postbit_attachment
  • (7)postbit_legacy
  • (7)postbit_onlinestatus
  • (7)postbit_wrapper
  • (4)showthread_bookmarksite
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper
  • (1)vbseo_linkbackmenu_entry 

Phrase Groups Available (6):
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files (39):
  • ./vbseo.php
  • ./env.php
  • ./vbseo/includes/functions_vbseo.php
  • ./vbseo/includes/functions_vbseo_pre.php
  • ./vbseo/includes/functions_vbseo_url.php
  • ./vbseo/includes/functions_vbseo_createurl.php
  • ./vbseo/includes/functions_vbseo_db.php
  • ./vbseo/includes/functions_vbseo_vb.php
  • ./vbseo/includes/functions_vbseo_seo.php
  • ./vbseo/includes/functions_vbseo_misc.php
  • ./vbseo/includes/functions_vbseo_crr.php
  • ./vbseo/includes/functions_vbseo_cache.php
  • ./vbseo/includes/functions_vbseo_hook.php
  • ./vbseo/includes/functions_vbseo_startup.php
  • ./includes/config.php
  • ./showthread.php
  • ./global.php
  • ./includes/class_bootstrap.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/functions.php
  • ./includes/class_friendly_url.php
  • ./includes/class_hook.php
  • ./includes/functions_cforum.php
  • ./includes/functions_facebook.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/class_bootstrap_framework.php
  • ./vb/vb.php
  • ./vb/phrase.php
  • ./packages/vbattach/attach.php
  • ./vb/types.php
  • ./vb/cache.php
  • ./vb/cache/db.php
  • ./vb/cache/observer/db.php
  • ./vb/cache/observer.php
  • ./includes/functions_notice.php 

Hooks Called (48):
  • init_startup
  • friendlyurl_resolve_class
  • database_pre_fetch_array
  • database_post_fetch_array
  • global_bootstrap_init_start
  • global_bootstrap_init_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • global_state_check
  • global_bootstrap_complete
  • global_start
  • style_fetch
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • friendlyurl_redirect_canonical
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • fetch_musername
  • cache_templates
  • template_register_var
  • parse_templates
  • notices_check_start
  • notices_noticebit
  • process_templates_complete
  • reputation_image
  • bbcode_parse_start
  • postbit_imicons
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • memberaction_dropdown
  • postbit_attachment
  • tag_fetchbit
  • tag_fetchbit_complete
  • forumrules
  • showthread_bookmarkbit
  • navbits
  • navbits_complete
  • showthread_complete


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1