How to set vb-code to a new xlsm with powershell

Hi,

i use powershell for many differnt thinks.
Now i want to grab some information, store it in excel and
for analysis i want to set some vb-code (macro) in the new file.

Can anyoneone show me a short example?

Thanks
Old House