Depending on how security is set up, you may be able to do it using
techniques
at Chip Pearson's site:

http://www.cpearson.com/excel/vbe.htm

I found this code on the site:

Sub AddModule()
Dim VBComp As VBComponent
Set VBComp = ThisWorkbook.VBProject.VBComponents.Add(vbext_ct_S tdModule)
VBComp.Name = "NewModule"
Application.Visible = True
End Sub

Looks like what I need - I'll give it a shot.

Or maybe you could just create the charts from Access--or create an addin
that
has the code already in it and you could just load that addin and run that
code.

Perhaps. I think what *should* be done is write it in C# with VSTO...

Thanks for the tip.