Finally made the module. Allows adding to other macros Some changes: 1. Replaced the variant variables with strings 2. Returning folder path will have "\" appended at end 3. User profile desktop returned as default Add this module to any macro VBA -> File -> Import File -> choose the .bas ...

@sloworks Thanks for the share!

CarrieIves suggestions on how I should be handling functions like this? Should I have a separate macro that basically just calls a function Create a module. You can reuse this module in each macro just import it when needed. The module file type is .bas and can be edited in any text editor (I sugge...