To get started, install ImportExcel
PowerShell module. Refer to ImportExcel Project for more details.
This code can be used in conjunction with the original CodeProject article published here
Repo structure
build.ps1
Build scriptvba\*
VBA filesconfiguraion.psd1
Configuration document containing path to the macro files and their module names
Example:
.\build.ps1 -data (get-service|select -first 10) -outputfile "C:\test.xlsx"