cmcreynolds
Active Member
- Joined
- May 21, 2015
- Messages
- 295
Hello,
Someone helped me with code similar to this three years ago, but I have since changed jobs.
I have four worksheets in my Excel workbook: Control, RptPg1, RptPg2, RptPg3
I would like a button (VBA? Macro?) for a user to press and it save all three pages into one PDF in a certain location (Let's say J:\\MainUser) with the quarter listed in the filename. (The quarter is in the Control workbook in cell E5). Ideally, the filename would be "Campaign Activity Report - [Cell E5].pdf"
Is this possible? Or could someone lead me in a direction to do this?
Thank you very much.
Someone helped me with code similar to this three years ago, but I have since changed jobs.
I have four worksheets in my Excel workbook: Control, RptPg1, RptPg2, RptPg3
I would like a button (VBA? Macro?) for a user to press and it save all three pages into one PDF in a certain location (Let's say J:\\MainUser) with the quarter listed in the filename. (The quarter is in the Control workbook in cell E5). Ideally, the filename would be "Campaign Activity Report - [Cell E5].pdf"
Is this possible? Or could someone lead me in a direction to do this?
Thank you very much.