Good afternoon!

I have created a series of macros for work that I use to analyze data. I would like to use these Macros on my home computers and my students would like to use them for analysis as well.

The problem is I am getting frustrated with having to go into my Macros and always change:
C:/Users/Danny/Desktop/ to C:/Users/Tina/Desktop/ to C:/Users/Becky/Desktop/ etc. How can I tell the macro C:/Users/ "ANYWHERE" /Deskop/?

Thanks! Bryan

PS - I am self-taught in programming so I don't have a large "tool box".