retrieve saved excel sheets from the specified path

[Robin Hood]

Hi

    I've saved excel sheets in a folder programatically. Can I retrieve them  programatically by specifying the name of the

excel sheet.

          I'm using LabVIEW 2009

[battler.]

You'll have to be more explicit about what you have done.  Are you using the report generation toolkit?  Did you generate/manipulate the data within an excel sheet and then save the file or are we talking about a simple file transfer operation? 

I'm quite sure it's the latter because if it were the former you wouldnt be having these problems 😉

Post your VI or a highlight your code on the block diagram and Edit --> Create VI Snippet from Selection.  Post the image.

[Robin Hood]

I'm using Report generation Toolkit. I've made a sub vi(for excel) anf have put it in the main vi. This sub vi(for excel) will

take data from the main vi and then save it.

[Robin Hood]

I've one more thing Battler. If I generate data and save it in an excel sheet with name VPA-1(say). Next time you run the 

code and if you give the same name(as VPA-1) for the excel sheet then it should ask "The file already exists, do you want

to replace it". I've made "prompt to replace button" true in "Save Report to File VI". But it is asking for every file

even if the file was not there actually.

[Robin Hood]

Hi,

     Can anyone help me out

[battler.]

For your 1st question, does this help?

http://decibel.ni.com/content/docs/DOC-3546

There is heaps of info about Excel development.  Search ni.com.

Also, have a look at the File I/O --> Advanced File Functions pallete.

[battler.]

Here's how to open Office (Excel or otherwise) if you don't have the Report Generation toolkit (such as I).

http://decibel.ni.com/content/docs/DOC-6843

[Robin Hood]

Thanks Battler. But, I couldn't  understand "No Error"  case section of the vi. can you explain what is happening in that case.

[battler.]

Can you post a block diagram image so we can have a look.

[Robin Hood]