Personal macro workbook for multiple users

[Mongy]

The quick question- What is the easiest "opt in" solution for "non expert" users to get a copy of a work built personal macro workbook (a PMWB with a number of work required macros) onto their machine?

I'm hoping for some guidance from those who may be more experienced (I'm not an expert, I tend to record a macro on work, and the hardest code I usually have to put in is a fill down to last row)

Longer explanantion-
With the pandemic, we have users who are working from our business location, and users who are using a remote desktop connection to a virtual machine.
One of the main issues which has arisen, is they may connect to a different virtual machine, meaning they will lose macros they've installed.
For users who have some ability, the macros are stored as VBA exports .bas files, and can import them within VBA.
For those with lesser ability, a dos batch file has been set up that attempts to create a XLSTART folder within their %APPDATA%\Microsoft\Excel, then copy the PMWB into this folder.
This is an OPT IN solution, and most of the users wouldn't have a PMWB to start with.
The macros are run over data which has been copied/pasted into a blank worksheet, or the opening of a file (there is no known file name to start with) and specific macro run.

Is there an easier solution to install the macro workbook into their current computer?
I'm looking for the easiest solution for users being able to use/download and use, a number of macros, and being able to advise when an update to the core macros mac occur.

I may not be using the right descriptions, but hope that makes sense.

 

[Dan_W]

Could you not distribute it as an AddIn (XLAM file)? Or does that suffer the same problem as the Personal Workbook?

 

[jkpieterse]

I would create an add-in and save it to a location all users have access to, regardless of how they log in. See: Excel: Create Addins

 

[Mongy]

With two answers pointing at addins, I've had a google and a read.
It does seem to point at making the process within excel itself, rather than copy/VBA.
Will do a bit more reading, and then move on to reading using user forms as a menu to call sub menus and run the macros.

Thank you

 

[Dan_W]

They aren't mutually exclusive. An add it is just a workbook that is deisgned as a kind of plugin to excel. It usually uses VBA and you can use userforms if you like. There are plenty of resources out there that make it really easy to make your own. It's one of the better ways of distirbuting VBA code.

 

[Dan_W]

Hi Mongy. How did you go with this, out of curiosity?