PB with read from spreadsheet : write my own question in dialogue box?

[david79]

Hello,

I have a little question on how to use the " read from spreadsheet " function. I have used it in my program and everything works fine. However I would like to write my own question when the dialogue box pops up. I don't seem to be able to find the "message " function in that VI ( such as the one in the open/create/replace VI ).

Any help would be great !

Thanks a lot,

david

[BJK]

Hi David,

Why don't you use them both!!

Use the Open VI to write your own "question" and connect the new file path to the Read from spreadsheet VI.

BJK

[david79]

Hi BJK,

Thanks a lot for ur reply !
I have tried ur solution and it works. If ever u have some time could u have a quick look at my very simple VI, to check if it is right? I want the user to confirm the writing in the file if it already exists. It seems to work but I am not used to using the TXT writing file.

If u don't have time don't worry,

Thanks again,

david

[david79]

right version of the prog

[BJK]

Sorry, don't have LabVIEW 7.1 !!!

BJK

[david79]

No probs,

Thanks anyway !

David

[david79]

Hello BJK,

Thanks for ur help, my program is now working fine. However I still have a problem with the date in excel. I am writing in the same column the date and the time whith the string : "d/mm/yyyy hh:mm:ss". The problem is that it writes ok the date and the time ( changing day works fine too ) but it sets a space before the first "d". So if I want to plot my results according to the time I have to take that space away and then it is ok.
Would u have any ideas how I could avoid having that space before the "d" in excel? ( I have checked with an indicator in labview and there is no space there when running ) ( and that space doesn't appear in any other column where I write some other stuff... )

Thanks again for ur help,

David

[BJK]

Hi David,

It is very difficult to tell what's going wrong, because I can't take a look in your code.

Place your code on the forum (I have version 7.0) and I or somebody else can take a look it.

Regards,
BJK

[tst]

Are you using "d" or "dd"?
If I understand your problem correctly, you are receiving thing like " 2/11...", instead of "02/11...".
If that is the case, try using "dd".
If this doesn't help, save back to 7.0 by selecting File>>Save With Options>>Save For Previous.