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
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