Hello guys,
I have a small problem with the case of combining few protected excels into one spreadsheet in one excel file.
Mainly i need the whole data from for example 8 protected with different passwords excels in one spreadsheet. I have for of course password for each excel. This is something that i need to prepare every week so i have a list of these passwords (they are the same every week for the excels). Is there any possibility to prepare any makro with the all passwords to combine these excels?
I have a small problem with the case of combining few protected excels into one spreadsheet in one excel file.
Mainly i need the whole data from for example 8 protected with different passwords excels in one spreadsheet. I have for of course password for each excel. This is something that i need to prepare every week so i have a list of these passwords (they are the same every week for the excels). Is there any possibility to prepare any makro with the all passwords to combine these excels?