Hi,
Can anybody help me with the following?
I have like 50 files on sharepoint on multiple folders that have password protected sheets and the files are setup wise completely a copy from eachother. However already have content in some places I can't loose. To prevent every time doing for 50 files resolving of one error. I would like to have a macro in a separate file that would:
1) Open the first file from a certain list, see example,without updating linked files and ignoring warnings
2) For each file remove the password protection (e.g. PASSWORD) from sheet Other Costs
3) Change the formula in cell D4 to =1+1
4) Put password (e.g. PASSWORD) back on sheet Other Costs
5) Close the file after being done, since they are on sharepoint with autosave, it does not even ask me to save when I close the file
6) Repeat from first step with second file, third and so on till last
7) Message displayed "All files handled"
Reason for preferring file one by one, if one goes into error, I can at least see that the ones before were handled.
Example of list:
Can anybody help me with the following?
I have like 50 files on sharepoint on multiple folders that have password protected sheets and the files are setup wise completely a copy from eachother. However already have content in some places I can't loose. To prevent every time doing for 50 files resolving of one error. I would like to have a macro in a separate file that would:
1) Open the first file from a certain list, see example,without updating linked files and ignoring warnings
2) For each file remove the password protection (e.g. PASSWORD) from sheet Other Costs
3) Change the formula in cell D4 to =1+1
4) Put password (e.g. PASSWORD) back on sheet Other Costs
5) Close the file after being done, since they are on sharepoint with autosave, it does not even ask me to save when I close the file
6) Repeat from first step with second file, third and so on till last
7) Message displayed "All files handled"
Reason for preferring file one by one, if one goes into error, I can at least see that the ones before were handled.
Example of list:
| A | B |
| 1 | sharepoint.com\file1 |
| 2 | sharepoint.com\file2 |
| 3 | sharepoint.com\file3 |
| 4 | sharepoint.com\file4 |
| 5 | sharepoint.com\file5 |
