How to save data in New Excel Sheet on each time run the VI?

[$anman23]

Hello everyone 

I am doing my dissertation. In that i have to store the data of load cell in the excel sheet. I have done that.

Here i have attach the vi , template in which want to save data named My , and output when complete the rn of vi named My Report.

Now the problem is once i have run the vi , my report is generated but second time when i run the vi the new my report sheet is not generated. and the second problem is i am getting out put as 511, 0,  2.49.  

I want the when ever i run the vi every time the new excel sheet should be generated and saved with date, time and my report tag. ex. My Report 20/11/13 12:00

And i want the output 511,2.49,...dont want this 0.

please hepl me out its urgent

[Pankajusic]

Hi anman23,

Please attach the subVi's used in " COM TO EXCEL WITH EXCEL TOOLKIT.vi". I want to see what you have tried.

[$anman23]

hi Pankaj

Thanks for rpl.

I have not used any sb vi. i have used the excel toolkit. and vi will run ony when com port is selected.

[Ranjeet_Singh]

Instead of that why dont you give save as option?

[$anman23]

hi ranjeet

thanks for rpl.

but how to give save as option in my vi?

[Ranjeet_Singh]

You just need to change the settings. Whenever it will write to excel it will display the save as option.

Then user will confirm the same

In the excel dispose report.vi passsave change and close report boolean input as TRUE and see