Hi, I have a question that i'm hoping someone has a solution for. Suppose an investor owns 3 companies: Company A Company B Company C. Each of these 3 companies have various financial deliverables in .pdf form (i.e. Financial Statements, IRR Reports, Investor Reports, ect...) that use a standardized naming convention. For example: Financial Statements - Company A (Q2 2018) Investor Report - Company B (Q2 2018) Additionally, all of the 3 companies financial deliverables are located in standardized file paths For example: Home > Company A > 2018 > Financial Statements Home > Company B > 2018 > Financial Statements Does anyone have experience with using a macro with similar criteria for printing documents? Any help would be appreciated.

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Using VBA to Print standardized documents from different file paths

Thread starter hutch27
Start date Jul 31, 2018
Tags

companies company financial standardized statements

hutch27

New Member

Jul 31, 2018

Hi,

I have a question that i'm hoping someone has a solution for.

Suppose an investor owns 3 companies:

Company A
Company B
Company C.

Each of these 3 companies have various financial deliverables in .pdf form (i.e. Financial Statements, IRR Reports, Investor Reports, ect...) that use a standardized naming convention.
For example: