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

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

Forum statistics

Threads
1,144,676
Messages
5,725,710
Members
422,636
Latest member
GatorsBucs

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