I need to export tables to an existing Excel file, how is that done?

[Jryan]

The example vi exports a table to a new Excel file that is opened using some programmatic approach that I am not familiar with.  Familiar or not, it opens a new excel spreadsheet, and I need to open an existing spreadsheet.  I need to be able to export more than one table, but I think that I can figure out the placement of the tables within the spreadsheet.  Bottom line, how do I open an existing Excel file to export tables to?  Is there any (intuitive) information on how to do this?

Thanks,

JRyan

[TiTou]

Hello,

If you start from the example and just replace the vi "open workbook" (that creates a new file) by the vi "open specfic workbook" (that opens the pointed file).
You will find this vi in :

    C:\Program Files\National Instruments\LabVIEW 7.1\examples\comm\ExcelExamples.llb\Open Specific WorkBook.vi

Then wire a file path transformed into string and there you are.

Hope this helps 😉

[Travis_M.]

Hello,

The examples help out a lot.  I assume you are referring to ActiveX as the unfamiliar.  Check out: http://zone.ni.com/devzone/devzoneweb.nsf/Opendoc?openagent&1744411D9B6C5820862567C2006DC236 for some good documentation on ActiveX.

Best of luck!