Turpis
Programmer
- Apr 16, 2002
- 151
Here is the problem:
I have several Excel workbooks located on terminals that accessible by multiple employees. These workbooks have password protecting the opening of them. Now there is a master workbook that links to all these various workbooks in the shop and gathers certain information when opened. Since these workbook have passwords to open the employee that has to open this master workbook wastes a lot of time typing in passwords. So my question is how to open all these linked workbooks that have passwords from the master but somehow skipping the password protection. I have no books in my possesion that even address VBAcode and how to apply it when dealing with the subject - linking workbooks.
I have several Excel workbooks located on terminals that accessible by multiple employees. These workbooks have password protecting the opening of them. Now there is a master workbook that links to all these various workbooks in the shop and gathers certain information when opened. Since these workbook have passwords to open the employee that has to open this master workbook wastes a lot of time typing in passwords. So my question is how to open all these linked workbooks that have passwords from the master but somehow skipping the password protection. I have no books in my possesion that even address VBAcode and how to apply it when dealing with the subject - linking workbooks.
