How to create an excel Pivottable-report from a dos command

[Guest]

I would like to know how to:
create an excel Pivottable-report from a dos command

Thanks, E.

 

[Guest]

Hi E,

You should be able to do this. I would suggest you write the code in Excel
first. Then when it is done and is working as you want, try using VBScript to
write some code that creates an Excel Application Object, and then you would
need to place the code you wrote in Excel in the VBScript file, making sure
you reference all the Excel VBA methods through the Excel Object that the
script has already created.

Once the script is written and works, place it in a location in the PATH
setting on your computer, or amend the PATH to include the script location,
and you can then simply type the script name from a command prompt.

Some help on scripting (including automation of Excel) can be found at:
http://www.microsoft.com/technet/scriptcenter/default.mspx
http://www.microsoft.com/technet/scriptcenter/resources/qanda/default.mspx

and here's an archive specific to Excel:
http://www.microsoft.com/technet/scriptcenter/resources/qanda/oct07/hey1017.mspx

I hope this helps,

Sean.