auto save spreadsheet file

[heang]

hello

i have tried to create vi to auto save table to spreadsheet. i am actually the novice of labview.

what vi desired function is the auto saving table to spreadsheet without asking user to key in the file name. i have used time and date to be the file name. but it appears "invalid filename". even it works, it is not what i want. as in real time, no user control. so i have to set the directory and file name automatically. without asking the user to click save file, how am i going to modify this vi?

thanks. in fact, i am already at my wits end.

regards

[becktho]

Hi

You use the "File Dialog.vi" in the attached vi. This function opens a file dialog - so if you don't want the user to enter a file-name, remove this function.

[altenbach]

As becktho already mentioned, you need to leave out the file dialog and built the file path manually. Here is one possibility (this is LabVIEW 8.0 so a few icons look a bit differently...)

In any case, you should NOT assemble any path with string concatenation functions followed by "string to path" because it will break portability of the code to different platforms. Instead use "built path" as shown above.

(Of course you are probably aware that you are not writing any proper excel files with your code.  ;))

Message Edited by altenbach on 01-15-2007 12:07 AM

[dctoni]

Hallo

I want to save automaticlly the file (spreadsheet) under the name of Date/time, so I did like Altenbach's suggestion but it didn't work . it keep telling me no path.

somewhere I read , I should put instead of ":" & "/" ---> "_" . any idea how?

Thanks in advance

Toni

[JeffOverton]

after the "to date and time strings" part wire the strings through a "search and replace"

Message Edited by JeffOverton on 04-10-2008 10:47 AM

[dctoni]

thx