Unfortunately I am using a macro in a separate workbook to pull data from each slide distribution day workbook, but the data will only pull if a workbook is titled Test Slide Distribution on the right path. The previous owner has many different cells tied to the specific naming conventions and it would take even longer to go through and change all of the necessary cells, also the cells that need to be copy and pasted must be changed occasionally to reflect new employees and so on. I ended up just manually resaving each one after pulling the data I needed. Thank you for the help though! If anyone else has an idea of a vba function at the end of a macro to copy something specific to the clipboard as text please reply!

That still doesn't warrant trying to put anything into the clipboard. If the save names occur in particular cells, it's a simple matter to insert those cell names into the save string without involving the clipboard. This can be done with any string you can put into the clipboard. However, since you really haven't told us anything much about what you're trying to achieve - instead of fixating on a particular approach - all we're doing is guessing.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]