Check out Chip Pearson's site:
http://cpearson.com/excel/vbe.htm
He shows how to write code that modifies code.
But there can be difficulties. If the workbook's project is locked or if the
user didn't allow any program access to the project, then you'll have trouble.
====
As an alternative, have you thought of creating a template (.xlt) that already
has the code in it?
JNW wrote:
How would I go about programmatically importing an exported module from a file?
Thanks!
--
JNW
--
Dave Peterson