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
Bookmarks