Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SPC XL and VBA
I installed an add-in called SPC XL 2007. It is a statistical analysis tool
for those who don't know. It builds nice charts. I have a column of data that I want to run the analysis on but I need to set the outliers before I make the chart. My outliers are 3x te average data. Does anyone have any experience using SPC VB objects and functions in the Excel VBE. I have the refrences installed for SPC but I cant seem to find any objects. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
SPC XL and VBA
I googled it and found this.....
http://www.sigmazone.com/spcxl_2007Beta.htm -- Regards, Nigel "Steve" wrote in message ... I installed an add-in called SPC XL 2007. It is a statistical analysis tool for those who don't know. It builds nice charts. I have a column of data that I want to run the analysis on but I need to set the outliers before I make the chart. My outliers are 3x te average data. Does anyone have any experience using SPC VB objects and functions in the Excel VBE. I have the refrences installed for SPC but I cant seem to find any objects. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
SPC XL and VBA
It's entirely possible that SPC XL 2007 was not designed to allow external
code to reference its internal procedures. In general, third party software doesn't expose hooks to its internal methods and properties. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "Steve" wrote in message ... I installed an add-in called SPC XL 2007. It is a statistical analysis tool for those who don't know. It builds nice charts. I have a column of data that I want to run the analysis on but I need to set the outliers before I make the chart. My outliers are 3x te average data. Does anyone have any experience using SPC VB objects and functions in the Excel VBE. I have the refrences installed for SPC but I cant seem to find any objects. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|