Dynamic Save to Folder Based on Cell Contents

Hello All,
Thanks to Mania112 I have a great code that sends a PDF via email of my worksheet. And thanks to Leith it is working wonderfully with the few tweaks he provided. Now I need to take it to the next level and could use some more help. Im not sure if this is possible but here goes:
I have my code creating a file name made up of text and cell references

Please Login or Register  to view this content.

On a shared drive I have folders for our different pieces of equipment. These folder names are the same as cell "C7" inputs in my worksheet. Cell "C7" is changed by the user when working on a specific piece of equipment, and is that equipments ID#. What I need to have happen is save the created PDF to the specific equipment ID# folder on my shared drive (H:/). This macro is fired by button click. The path to the proper folder would need to change every time cell "C7" changed in order to go into the proper folder. I assume this save would need to happen prior to the killing of the temp file. But where exactly, and what would I need to have as the code to do this dynamic save?
Thank you all in advance for your help. Here is the full code I have.

Please Login or Register  to view this content.

I hope everyone had a good weekend.

Any thoughts on my question above?

Thanks Leith. I'll give it a try and let you know. I appreciate you help once again.

Hi Leith,
I have tried the code and unfortunately have had no luck. The macro will run without errors, but no longer creates the .pdf in the email, nor saves to the shared drive. I have tried manipulating the code to the best of my ability but fall short. Any other thoughts on how I might accomplish it? I have attached a workbook for an example of what Im trying to accomplish.

Also, to help clarify the path it would need to be as follows:

H:\Folder1\Sub Folder1\Sub Folder2\QC Sheet\Sheet Range "C7"\ & TempFileName

The Sheet Range"C7" is a user input for an equipment number. Each piece of equipment has its own folder so the save would need to be directed to the proper folder based on C7.

Thanks for the help.