Hi,
I've searched the forums a bit and haven't found exactly what i'm looking for, so i'm wondering if anyone here can point me in the right direction.
Background:Each quarter, members of my team need to print financial reports for different companies. Each company's files are located in a different folder on my computers drive. So, for example, Company A is located at Users\Companies\Company A\Reports while Company B is located at Users\Companies\Company B\Reports. Each company sub folder contains reports all labeled using standardized naming conventions. I'm looking to find a macro that will print only the reports in this folder using a mapping table i have created.
Clicking on the following file paths will show:
I'm not expecting someone to suggest a code based on my request description (since I may have been vague), i'm more-so looking for guidance on how to make this possible.
I've searched the forums a bit and haven't found exactly what i'm looking for, so i'm wondering if anyone here can point me in the right direction.
Background:Each quarter, members of my team need to print financial reports for different companies. Each company's files are located in a different folder on my computers drive. So, for example, Company A is located at Users\Companies\Company A\Reports while Company B is located at Users\Companies\Company B\Reports. Each company sub folder contains reports all labeled using standardized naming conventions. I'm looking to find a macro that will print only the reports in this folder using a mapping table i have created.
Clicking on the following file paths will show:
- Users\Companies\Company A\Reports
- Company A - Financials (Q3 2019).pdf
- Company A - Reconciliation (Q3 2019).pdf
- Company A - Investments (Q3 2019).pdf
- Users\Companies\Company B\Reports
- Company B - Financials (Q3 2019).pdf
- Company B - Reconciliation (Q3 2019).pdf
- Company B - Investments (Q3 2019).pdf
I'm not expecting someone to suggest a code based on my request description (since I may have been vague), i'm more-so looking for guidance on how to make this possible.
Last edited: