12-05-2005 11:30 AM
12-05-2005 12:58 PM
There are a couple of ways to do this. First, what version of LabVIEW are you using and do you have the Report Generation Toolkit for MSOffice?
If you have the Report Gen toolkit then there is quite a few VIs written to do what you want for Excel. you just need to put them together int he order you need.
If you do not have the report toolkit then you are corrct you will need to use the ActiveX controls to get Excel to work the way you want.
There is a couple Excel examples within LabVIEW that you can look at for a start with ActiveX. the example would be found on your PC here:
C:\Program Files\National Instruments\LabVIEW 8.0\examples\comm\ExcelExamples.llb (where the LabVIEW 8.0 Directory would be whichever version you use currently)
When I started on a couple of projects here at work, we had LabVIEW 6i Full Dev system without the report gen toolkit, I learned some ActiveX commands and things then. Now that I have been upgraded to the Pro-Dev Suite I have the report Gen Vis and have since switched to those as they seem to work better.
when you reply, if you don't have the report gen toolkit I can search through my older code and post a couple of ActiveX vis for Excel that I have done if you would like
Jeff