VBA Script to run from separate file instead of current excel workbook

I currently have a bit of code that is written and working just the way I want it to. This code resides in a workbook called "timeclock codes" the VBA extracts data from this workbook another workbook called "quickbooks file", dumps it into a worksheet and saves it. What I would like is to have a workbook called MACRO or something along those lines that would have the code, this way an employee could open the generated "timeclock codes" file and "quickbooks file", and the macro file, preferably with a button that simply says "Run Macro" and does what I wrote it to do.

I feel like this should be a set of simple changes, but I have been learning as I go, and receiving a lot of help, and am not sure I know how to do this....

Hi

Are you aware that each user has a personal workbook that is opened whenever they run excel?

This is normally hidden.

But you can record a macro to this workbook.

open excel

unhide the personal workbook

Open visual basic

paste your macro into a module in the personal workbook ( view project explore will show you what modules are available. Insert new module if none exist)
hide personal workbook

Quit excel making sure to save changes to personal workbook when asked by excel.

I could be wrong, but would the code not still need to be modified?

Do you need help amending it?

I assumed that you had written the code.

Nope, a few minor tweaks and it worked great! Thank you, I had NO idea this existed!