Error -214682728​4

[Microsystem]

The execution is attached in the attachment. The code basically copies a portion of the data from Excel file A sheet A over to another Excel file B sheet B. The Error -2146827284 was generated during the worksheet copy operation. I have searched in the forum but have not found any similar problems. Can some one help me with this? Thank you.

[kbbersch · Accepted solution]

This error can happen if either sheet doesn't exist or you're trying to copy an empty range.  Check to make sure the sheets actually exist with the exact name.

[0utlaw]

Hello Microsystem,

The error you're getting (hex code 800A03EC) is a Microsoft Office generic error rather than a LabVIEW error. It's likely that something's not configured properly (such as a file path or worksheet name), I'd definitely recommend attempting to perform the same operation using the LabVIEW Report Generation Toolkit if you have access to it.

Has this code worked in the past?  Do both the source and target worsheets exist? Does this code work with other files? Are there other operations (besides copy) you've attempted that do work?

I'd also recommend replacing your string path controls with actual file path controls- this will allow you to select files rather than needing to type them and will reduce user error.

These NI KnowledgeBase search results are specific to the Report Generation Toolkit, but reading through them might also give you some insight into what's failing in your own code:

http://search.ni.com/nisearch/app/main/p/bot/no/ap/tech/lang/en/pg/1/sn/catnav:kb/q/-2146827284/

Regards,

[Microsystem]

Thank you, kbbersch and 0utlaw. The temp file is not recorded right and it is empty. During the file copy, the error is generated to show an empty range. The file/folder names are correct.