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.
You can export the output in various ways, either by exporting it to Excel (from within PC-DMIS, easiest) or have Excel fetch the values from your partprogram (harder). You have the PCD2EXCEL wizard to help you with the export, which will automate the export to Excel, but you would need something in your Excel workbook that does the rest - a macro perhaps?
Doesn't the PCD2EXCEL wizard append the file by creating a new worksheet each time it updates? Like I said I know very little about visual basic or creating macros. If you can point me in the right direction I may be able to figure it out though. In the mean time I will try to make something work with the PCD2EXCEL.
You can export the output in various ways, either by exporting it to Excel (from within PC-DMIS, easiest) or have Excel fetch the values from your partprogram (harder). You have the PCD2EXCEL wizard to help you with the export, which will automate the export to Excel, but you would need something in your Excel workbook that does the rest - a macro perhaps?
Doesn't the PCD2EXCEL wizard append the file by creating a new worksheet each time it updates? Like I said I know very little about visual basic or creating macros. If you can point me in the right direction I may be able to figure it out though. In the mean time I will try to make something work with the PCD2EXCEL.
