I need a script in VB (.VBS) that when run will populate the 1st row and each column going left to right on every worksheet in a single excel file such as this:
ColA ColB ColC
1 ITEM DESCRIPTION PRICE
The sole purpose for thie script is to create a header only, there is more than 3 columns to add but if I could get the three and shown how to add in more columns that would be great! Please note, not needing a macro, this will all be run from a script at the command prompt for automation purposes.