Excel Report Preview (Error -2146827284)

[gvagenas]

Hello,

I am trying to preview the report of an excel file. The file has 34 sheets. It works perfectly for the first 27 iterations but then it gives Error -2146827284 after the Worksheet invoke node. Any ideas? I am attaching a snippet of my code.

[aputman]

I'm trying to figure out what you are doing here and what you want to do.  What is the purpose of iterating thru the worksheets, selecting them and then do nothing with the selection?  Is this supposed to print preview each worksheet and close the preview automatically?  What is the purpose of the window handle?

[Bob_Schor]

Sigh.  My Reputation hasn't spread sufficiently far, so ...

Attach Code, not pictures (especially not teeny tiny pictures that can't be easily viewed).  

Unless the Picture happens to be a LabVIEW Snippet, it also cannot be "closely inspected" (i.e. we can't "see" the other Cases of a Case Statement), cannot be edited (to fix and test bugs), and cannot be executed (to understand why it doesn't work).

Bob "No Pictures, Please" Schor

[aputman]

---

@Bob_Schor wrote:

Sigh.  My Reputation hasn't spread sufficiently far, so ...

---

Bob, maybe you could have a hand in composing this message.