Personal macro workbook for multiple users

Mongy

Board Regular
Joined
Dec 9, 2002
Messages
51
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.
 

Some videos you may like

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

Dan_W

Active Member
Joined
Jul 11, 2018
Messages
258
Office Version
  1. 365
Platform
  1. Windows
Could you not distribute it as an AddIn (XLAM file)? Or does that suffer the same problem as the Personal Workbook?
 

Mongy

Board Regular
Joined
Dec 9, 2002
Messages
51
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

Active Member
Joined
Jul 11, 2018
Messages
258
Office Version
  1. 365
Platform
  1. Windows
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

Active Member
Joined
Jul 11, 2018
Messages
258
Office Version
  1. 365
Platform
  1. Windows
Hi Mongy. How did you go with this, out of curiosity?
 

Watch MrExcel Video

Forum statistics

Threads
1,118,656
Messages
5,573,438
Members
412,529
Latest member
cTatch
Top