LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Excel copy from cell to cell

Solved!
Go to solution

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
(187 Views)
Highlighted
Solution
Accepted by 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.
-------------------------------------------------------------------------------------------------
Certified LabVIEW Architect, Certified TestStand Architect
Message 2 of 4
(145 Views)
Solution
Accepted by Zheng1970

Use the Worksheet->Range node for your destination.

Example_VI_BD.png

aputman
LabVIEW 2017
LabVIEW Programming
Message 3 of 4
(139 Views)

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

0 Kudos
Message 4 of 4
(130 Views)