Write To Spreadsheet File issue

[suneelkv]

Hi Friends,

I am facing a new issue in on of my VI.

Please see the attached snapshot of the same.

I'm using this Wrtie to Spreadsheet file.vi in one of my VI's.

As a simple VI its working fine.

But when i am running from applicaiton thru some VI and using as a SubVI

Its giving this issue.

Can some body explain what this error exactly means?

THat would be very appreciable.

Cheers,

Suneel.V

[Deepu]

I believe the problem is with the File Path. Try putting a 'probe' at the file path input of the function and see if the path is correct and all the folders in the path given are already existing.

Message Edited by Deepu on 07-11-2008 02:38 PM

[muks]

The error msg says it all doesnt it? "New I/O attempted with old I/O in progress"

U have opened a file and on top of it u r trying to write something.Post ur block diagram we could suggest changes.

[Deepu]

Are you trying to write to a same file, same time more than once ? Or are you trying to write to a file opened and locked by MS Excel ?

As muks suggetsed, post your code rather than front panel screen shot so that it would help us better understand ur code.

Message Edited by Deepu on 07-11-2008 04:53 PM

[GerdW]

Hi muks,

this "New I/O attempted with old I/O in progress" is a GPIB-related error message. As Suneel is dealing with file access (WriteToSpreadsheet!) the other description "duplicate path" is the interesting one here...

As I never had this error message before I also would suggest attaching your vi (or a stripped down version) here!

[Deepu]

Probably the solution is here

It goes like this:

"The New File function cannot overwrite an existing file unless overwrite is set to TRUE and the existing file is not set to Read Only. If you try to overwrite a file without the correct permission, this function does not create or open a file, and the function returns error 10.

To avoid this error, wire a boolean constant of TRUE to the overwrite input of New File."

Hope it helps !

[suneelkv]

Hi Deepu/muks

Before adding the VI one interesting thing i found from my VI

With the Excel_Input_Automation.xls i am facing this issue.

If the content of the same excel sheet i copied one more VI and try to run the same...

the issue is not observed,.....

So is there anything to do with the excel sheet.

I will add my VI's soon.

CHeeers,

SUneel

[muks]

Gerd,
          Just name the xl to readonly and try writing data into it.U will get the same error. Right?

[muks]

---

If the content of the same excel sheet i copied one more VI and try to run the same...

---

I dont get it.

[suneelkv]

Hey sorry folks,

I've given a wrong info in my above posts.

That issue is also seen even i copied the content to other excel sheet.

But i couldnt reproduce it everytime.

Thats what the issue with...

Today night (i.e 6:00 P.M) IST i would be sitting and debugging that issue..

Please assist me from then on.

Right now hardware is not available.

-Suneel