Grab values in labview from excel

[at2bob]

This is a 2 part question:

1. I have a VI that writes data to excel but i want to leave my original file intact and save as different name, i keep getting an error

2. for the new name i want to append a timestamp but cannot find how to get the PC current time

any help would be appreciated, i've attached the VI and a sample spreadsheet

i'm using LV 2012 and office 2007

[aputman]

Check your filename.  You have some '/' which are invalid characters.  Remove the random number generator...not necessary.

[ben64]

Here's one way to generate the PC date and time string.

Ben64

[ben64 · Accepted solution]

Simpler way

Ben64

[at2bob]

thanks, got it working

[fasp]

Good afternoon,
 
How do I write values from a chart in labview to Excel by pressing a button in labview ? When i press another button the stop to grab values.

In the final the values stay in directory when i can consult.
 
I would appreciate help please.
 
FASP

[FoxSquirrel]

You could always drop a property node to get the values from the chart and then write to a csv file.  Or, you can also always right click on a chart in LabVIEW and choose to export to Excel.