LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Excel copy from cell to cell

Solved!
Go to solution
Highlighted

Hello,

 

I am trying to use ActiveX to copy cell to cell with copy method of range. What should be data format of  destination?

 

Thanks!

0 Kudos
Message 1 of 4
(354 Views)
Highlighted
Solution
Accepted by topic author Zheng1970

You cannot put a single cell there. It has to be a range. Create a range with the cell you want to have it copied to and it should work.

Destination	Optional	Specifies the new range to which the specified range will be copied. If this argument is omitted, Microsoft Excel copies the range to the Clipboard.


Message 2 of 4
(312 Views)
Highlighted
Solution
Accepted by topic author Zheng1970

Use the Worksheet->Range node for your destination.

Example_VI_BD.png


aputman
LabVIEW 2017
LabVIEW Programming
Message 3 of 4
(306 Views)
Highlighted

Thanks so much! It bothers me several days, I can have a nice sleep now.

0 Kudos
Message 4 of 4
(297 Views)