ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   SPC XL and VBA (https://www.excelbanter.com/excel-programming/425010-spc-xl-vba.html)

Steve

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.

Nigel[_2_]

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.



Jon Peltier

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.





All times are GMT +1. The time now is 08:00 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com