auto save spreadsheet

[heang]

here, i have few questions. i hope that these wont get
you in trouble.

1)i have been trying to save file to spreadsheet in
series with the file name according to the time and
date. however, what i desire is that the vi save
automatically with its file name generated by time and date. what i did is
without using the file dialog, the vi can save but it
appears the message asking user to key in the file
name.can its file name generated from the time and date?what i previously did is using 'write to measurement file'(so that its file name can be generated according to time and date), and now i have already one table in main vi.therefore, i wish to save the table directly to spreadsheet.

2)another method i used is to open the subvi of the
'write character to file', try to modify the 'new
file' sub vi. i try to save with different subvi name.
but finally in the main vi, it shows no difference.the
modified sub vi is added with 'pattern', 'default
name' control.i want these 2 controls to appear as the
control of the vi of 'write character to file'.but
after several attempts, i fail.


3)in one vi, creating the sub vi can only be done
after all algorithm is finished?i think this question
more or less related to the 2nd question i ask.when
the subvi is done, how to put the desire control and
indicator of subvi to be appear in  main vi.

look back my questions, i doubt that u may not
understand what i m saying.i hope that it wont trouble
you much to give me some pieces of technical advice. i
appreciate the assistance from you

here attached with the vi

thanks
regards
leow

[Dennis_Knutson]

Answering a question won't get anyone in trouble. You could use a bigger font though to make your question easier to read though.

The problem you are having is that you are building a an invalid path. You could have seen this yourself by simply probing the path input to Write Characters to File. There are illegal characters in the date and time strings. I would replace the '/' and ':' characters with the underscore '_' character. It also seems like you want to create a folder with the date name and a file under that folder with the time as the name (and no extension)? If you want the date and time both to be part of the file name, you need to concantante the strings before wiring it to the build path. I would also suggest you add a default path to the base path input (i.e. c:\) or use the current VI's path as the base path. I would suggest you create a small VI with just the code for creating a path. When the path is the way you like it, then move it to the VI with the write file stuff.