How can I save excel spreadsheets automatically which are created with activeX with ongoing filenames.

[German]

Hi, maybe someone can help me!
I run a continuous measurement and shall save the data of each measurement in a new excel file. I have already created a path with activeX. So every new data is stored in a new workbook but without a filename. So my question is how can I save automatically every new excel file with a new ongoing name e.g. time/date?

Thank you very much,
Birgit

[Gorka Larrea]

When you use activeX to create a new workbook, you can set the filename, and later when you write the data save it. Another way is to use "SaveAs" node.
I've attached a small vi that i created to pass it a Excel application refnum and create a workbook in the wanted path. Works for LV 5.0 (suppose there's no problem in that) and Excel 97 (this can be a problem if you have another version.
Hope this helps