Do you mean macro-expansion? I am not sure how to do that with VB... you could probably do it if you used Windows Scripting Host but I have no experience in that area.

If you want, you may check out www.planetsourcecode.com/vb for tons of examples on this subject.