I am in a networking environment and we are recordingmacros to run on
standard, .csv reports for limited usage by individuals. Most people
recording the initial macros are beginner to intermediate users trained to
use the macro recorder and we are trying to keep it simple. So far the
easiest way to distribute the macro is to open the Visual Basic Editor,
export the module with the macro, email it or copy to the end user, then
import the .bas file onto specific user's computer.

Our problem is that most users have never created a macro, let alone one
saved in the personal macro workbook and therefore there is no PERSONAL.XLS.
The work-around is to record a short macro in the Personal Macro Workbook,
thus creating the PERSONAL.XLS. Is there a more elegant solution?

Copying someone's PERSONAL.XLS to another computer copies too many other
macros.