The title may be confusing, so here is my question. Is it possible to create a file with EXcel using VB and then create a macro to insert to that file for later use. I know how to create excel files using vb, I did that quite a lot recently, but what I was wondering is the part about the macro. Is it actually possible to add a macro (already created or not) to this excel file.
I know this, to some extent, is functional programming and I doubt VB support that kind of programming, but I wish I was wrong.

It's not really a big deal if I can't do it, I just thing that it would be nice if I could add some macro programmatically to a file...