Pteroglossus
New Member
- Joined
- Nov 19, 2020
- Messages
- 3
Hi everyone,
For my first two VBA projects, I was able to find answers on this forum in threads closely related to what I wanted to do. This time I'm at a loss!
At work, we're required to send monthly reports of hours worked by each of our 25 team members.
Each agent keeps track of their worked hours in a workbook, composed of monthly sheets named 'January 20', 'February 20', all stored in the same folder.
I'd like to build a macro that would cycle through all the workbooks and export, for instance, the 25 individual 'November 2020' sheets into a single PDF using "ExportAsFixedFormat".
Ideally, as the agent in charge of doing that is not computer-savvy, a simple button that would open a dialog box with a drop-down menu of the selectable /months sheets would be great.
I think I could use the code described here for the "loop" part of the macro, but how would I go about including the dialog box and drop-down menu listing all the sheets' names?
Thanks for any assistance you might provide!
Kevin
For my first two VBA projects, I was able to find answers on this forum in threads closely related to what I wanted to do. This time I'm at a loss!
At work, we're required to send monthly reports of hours worked by each of our 25 team members.
Each agent keeps track of their worked hours in a workbook, composed of monthly sheets named 'January 20', 'February 20', all stored in the same folder.
I'd like to build a macro that would cycle through all the workbooks and export, for instance, the 25 individual 'November 2020' sheets into a single PDF using "ExportAsFixedFormat".
Ideally, as the agent in charge of doing that is not computer-savvy, a simple button that would open a dialog box with a drop-down menu of the selectable /months sheets would be great.
I think I could use the code described here for the "loop" part of the macro, but how would I go about including the dialog box and drop-down menu listing all the sheets' names?
Thanks for any assistance you might provide!
Kevin