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.
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.