Results 1 to 9 of 9

Replace all matching sheets

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-07-2011
    Location
    Bhutan
    MS-Off Ver
    Excel 2007
    Posts
    244

    Replace all matching sheets

    Hi friends,
    I am stuck at a point and need some help.
    I have an excel file in which I update some information's, then I want to replicate the sheets in different folders and in different file.
    I have a dummy sheet for reference, called "Master"
    In column A I have inserted the folder location.
    In column B I have inserted the sheets that will be copied from the current master file and replace in all the folders and files in location of Column A.

    Means for example: in "C:\Testing Update\ " there are four folders with different name. each containing one or two files whose sheets are protected with password "Alpha2012". Now these files contains the exact sheet name that is present in the master sheet.(example : A,B,C,TCODE_P001 etc.) What I want is to unprotect the sheets, replace the sheets from master file without tampering any other sheets and again protect the sheet and save it. In all the files in the location "C:\Testing Update\ " then in the location "D:\Testing Update2\" (The password for all the files in this location is "Alpha2011")

    Please help me. thanks in advance.
    regards,
    me
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1