Here is one for you guys, I need to output data from PC-DMIS to an excel or other type of file where it will automatically average the results from a run of three parts and chart those results. The higher ups want real time data without paying for datapage+ or another SPC software such as QC Calc. Keep in mind I am by no means even a beginner let alone an expert with VB scripting.
Is there any advantage to having Excel fetch values?
Not really, rather the reverse. If you use PCD2Excel, it's Wilcox' responsibility that the exported data are correctly input in Excel and they (supposedly) know how to do it. If you write an Excel macro of your own, it's your own responsibility,
and you have to figure out how to get the correct data from all the different dimensions. I've done it, and it's not an easy task (adding FCF dimensions more than doubled the size of the macro).
The plus with writing your own importer in Excel is that you can (hopefully) fix it when you find a bug. With PCD2Excel you'll have to wait...
Edit to add: Of course, if you are trying to fill a custom form in Excel it will be much easier to do it all from Excel.
Is there any advantage to having Excel fetch values?
Not really, rather the reverse. If you use PCD2Excel, it's Wilcox' responsibility that the exported data are correctly input in Excel and they (supposedly) know how to do it. If you write an Excel macro of your own, it's your own responsibility,
and you have to figure out how to get the correct data from all the different dimensions. I've done it, and it's not an easy task (adding FCF dimensions more than doubled the size of the macro).
The plus with writing your own importer in Excel is that you can (hopefully) fix it when you find a bug. With PCD2Excel you'll have to wait...
Edit to add: Of course, if you are trying to fill a custom form in Excel it will be much easier to do it all from Excel.
