I'm having trouble with some macros and I don't know if I need to combine them or edit?

I have to copied and pasted two macros to my spreadsheet attached to control buttons.

One control button "save as" the active workbook to a specific folder on my shared drive under a name specified by two cells on the spreadsheet. The workbook is an "end of shift" report for supervisors and will be saved to the folder 3 times a day.

The other button copies the spreadsheet into a PDF and attaches it to an email.

I copied these from some videos I watched and made the appropriate adjustments to fit my spreadsheet. I in no way know how to write a macro.

I realized after getting done it would be better to attach the newly saved file to the email instead of a PDF because then the next supervisor can just take the already filled out end of shift report and edit any changes that occurred on their shift and use the "save as" control button again to create a new workbook for their shift.

I don't know if I make edits to the "save as" control button to just have it also attach the newly created workbook to an email, or

If I edit the email control button to grab the newly saved workbook from the folder on the shared drive and send it.

The two macros I used will be pasted below. I would greatly appreciate any help from the experts here.

Thank you!

-----------------------------------------------------------------------------------------------------------------------------------------------------

Please Login or Register  to view this content.

-----------------------------------------------------------------------------------------------------------------------------------------------------

Please Login or Register  to view this content.

Administrative Note:

Welcome to the forum.

Is your forum profile showing the Excel PRODUCT that you need this to work for?

Members will tailor the solutions they offer to the Office PRODUCT (Excel, NOT Windows) that you have. Please check that your forum profile is up-to-date in this respect. If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. If your product is for Mac, please also state this.

The three most recent Excel products are Excel 2019, Excel 2021 and MS365 - if you are using MS365, please give this name along with the version number in your profile (e.g. MS365 Version 2306). This is in the About Excel section further down the Account page.

Thanks.