Write to spreadsheet file common path dialog

[pokerprof]

Hi guys,

I am facing a road block here. 

I am currently using Create File (unwired file path) so that the user can input the file name "test.txt" to create the txt file. No problem here. 

However, I want this newly created text file to be my file path to my Write to Spreadsheet File.

Please see attached photo.

Help ! Kudos and thanks !

[KoenR94]

didnt work

[GerdW]

Hi poker,

two ways:

Either close the file to get the path or use the file dialog express VI instead...

@Koen:

When the path is provided as "a:" (as is in the given example) then WriteSpreadsheetFile will give an error or does not provide the functionality as requested...

General hint:

Using WriteSpreadsheetFile is a quick way to write CSV files, but has the disadvantage of not providing error I/O connections. And you can't prevent error dialogs generated inside this function... It's (most often) quite easy to use simple file functions in conjunction with ArrayToSpreadsheetString!

[udka · Accepted solution]

Why not use Build path? and then send it to Write to spreadsheet file.

[GerdW]

Hi Uday,

did you test your suggestion? OpenFile outputs a file reference, not a path...

[udka]

I mean't use the new file name as string to the build path and the base path as folder path.
Can't we do that way?

[pokerprof]

Thank you for the input guys.

I have solved it using Build Path.

This is how I did it:

Prompt user input. Output string to the Build Path. The appended path string goes to the file path of Create File. I also create a local variable of the appended path string and it goes to Write to Spreadsheet File.

There you go. Thank you and kudos !

[udka]

Hi pokerprof,

Most welcome it helped.

[GerdW]

Hi poker,

---

I also create a local variable of the appended path string and it goes to Write to Spreadsheet File.

---

Why do you need a local variable for that purpose?

[pokerprof]

Hi,

Cause the write to spreadsheet is inside a while loop and many other case structures. So I guess it is easier to just have a local variable to do the job.