How to apply VBA code to other Excel files by PowerShell?

[brendon007]

How do I use VBA code in other spreadsheets? Doing this through PowerShell. It is possible to generate a generic file just with VBA for this purpose.