Hi,
I am using a cRIO with LV7 (will be upgrading to 8 at another time).
Currently I have a cRIO program that performs some operations and writes data to an xls spreadsheet (program written by someone else) I think it's just writing to a text file with a *.xls extension because I'm able to open this file with notepad and I see comma delimitted data. The file is created at the beginning of the program, and data is appended to it as the program runs. Everything works fine there..
Now here's where I need to get to:
I have this excel workbook (whatever excel calls their files these days) that contains some macros. It has two worksheets. The first page will be blank and will have data added to it. The second worksheet has a macro to draw a chart. This excel workbook will be my "template" and will reside on the cRIO.
I need to do the following to replace the file save operation given above. (rather than opening an appending to a text file with an xls extension)
1) Create a duplicate copy of the excel workbook with a user defined filename. (essentially creating a new excel workbook to put data into but it will also contain the macro)
2) Write data to this spreadsheet, but only on the first worksheet. (the blank worksheet).
When I open the file in Windows I get the "Macro warning blah blah" message. I'm concerned that this will pop up in Labview. If so, how does Labview handle this?
How do I ensure that I only write to the first worksheet of the workbook?
Any advice is greatly appreciated!
Regards,
Jeff
