Writing to an Excel Template without showing

[Nghtcrwlr]

Hi all..

Please have a look at the attached VI. (LV7.1)

I have tried to open n existing template and write some data at particular cells. I dont want the Excel to open up and show.... it should automatically write.

Message Edited by Nghtcrwlr on 07-22-2009 04:49 AM

[SanRac]

HI

I think the best way to do this you can use "MS office Report" express vi.

Hope this helps

Regards

Santosh

[MikeS81]

Hi Nghtcrwlr,

see the attached picture. It should work for you.

Mike

[Nghtcrwlr]

Hi ..

I tried to solve that problem. But now 2 errors comes up. One is attached below. and the other is LV crashes suddenly... any idea???

[MikeS81]

Hi Nghtcrwl,

you got this message, because you never close the document and excel. Why didn't you try it like shown in the picture before?

Mike

[Nghtcrwlr]

Sryy.. i didnt notice ur message before posting. I tried with what u mentioned. See the attchment. But now i cant open the Excel in a normal way . When i open it from the folder, it jus appears for a second in the screen and goes off... why is it so?

[MikeS81]

Hi,

it's because of the close methods at the end. If you want to edit the file manually, then you have to disable them.

Mike

[Nghtcrwlr]

Hi Mike..

i removed both close methods at the end. STill its not wrking.

[MikeS81 · Accepted solution]

Hi Nghtcrwl,

add the "visible" property to the first property node an connect a true to it. The first worksheet is index 1.

Mike

Message Edited by MikeS81 on 07-22-2009 03:17 PM

[Nghtcrwlr]

Hi Mike

Thanks...

One more question. What if i want to save the opened template in another name and at another folder? I tried to change the invoke nodes at the end to method "save as" but didnt work.