Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to create an excel Pivottable-report from a dos command
I would like to know how to:
create an excel Pivottable-report from a dos command Thanks, E. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to create an excel Pivottable-report from a dos command
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/scr...r/default.mspx http://www.microsoft.com/technet/scr...a/default.mspx and here's an archive specific to Excel: http://www.microsoft.com/technet/scr...7/hey1017.mspx I hope this helps, Sean. "E." wrote: I would like to know how to: create an excel Pivottable-report from a dos command Thanks, E. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
PivotTable Report - NEW USER | Charts and Charting in Excel | |||
Report Filter in PivotTable | Excel Discussion (Misc queries) | |||
Excel 2007 PivotTable Report Filter area not working | Excel Discussion (Misc queries) | |||
How does one get the PivotTable report info that feeds another PivotTable report? | Excel Programming | |||
Creating a PivotTable Report from an Another PivotTable Report | Excel Programming |