VBA to Auto open password protected XLSM files.

vips9876

New Member
Joined
Jan 29, 2021
Messages
1
Office Version
  1. 365
Platform
  1. Windows
I have a Destination file that needs to gather information from multiple XLSM source documents. Each of the Source documents have different passwords so I would like a way to have other managers open the destination file and not have to enter the source document passwords. Also I don't want the source documents to be visible to anyone opening the destination file.

Source document 1 file name: \\alex\comm\sales\team\andy.xlsm
Password: XXXX

Source document 2 file name: \\alex\comm\sales\Office Equp\erin.xlsm
Password: YYYY

Thank you for the help - I have read other versions of this code but when I run the code it opens the source documents and then leaves them open
 

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

Forum statistics

Threads
1,144,629
Messages
5,725,390
Members
422,623
Latest member
Dave52

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top