Manual copy paste excel value

[klaz]

I have a vi which allows users to manual input numeric values (hex). It's a numeric control. However, I found that whatever they copy from Excel cell can't paste into the numeric control front panel. If they copy the content but not the cell, it works. Any clue for this issue? I guess it has to do with the way excel cell is copied.

[RavensFan]

Exactly.  The contents of an Excel cell is text data that can be copied.  The entire cell itself is an object full of properties.  LabVIEW wouldn't know how to handle that object.  Suppose you actually copied a range of two cells, how would you want LabVIEW to handle that?

[hecmar.arreola]

I asked a similar question here:

http://forums.ni.com/t5/LabVIEW/Control-that-supports-copy-paste-from-Excel/m-p/1005498

And I believe I came out of it with a working solution.  Hopefully this works for you as well.

[Samuel_S]

The Link above is a very good tool to use when trying to solve an Excel copy and paste issue. You can also use an Microsoft Office Excel Spreadsheet Active X control to control copy and paste. I would recommend using a button on the front panel which takes just the text from the cells and not the object.