How to create a macro in excel 2010 to work in more than one PC after saving with a new na

Hello

I have created an excel workbook with some macros in order to improve the work and decrease the time.

the workbook is good to send the e-mail with macros but when the other people try to click the ( Save File As Pending ) it gives me an error

I need to make the file works in booth PC's

1- technical support fill the info, then send , then save & clear to erase the information & generate another order No.
2- Fleet service when receive first step is to save as pending. in the section i created in the macro.
3- After order done he will open the file from the folder as per the name and fill the information then send , and save to close the order.
4- technical support receive the file and fill the remarks and save to close >

after that print the file to make it in the Truck file.

can any one help me.

my problem is how can I make this file work with macro after name changed and to save in the path as per my path

Thanks

This is my macros in the attachments