Copy and paste data

[leiabcn]

Hello,

I am having a problem with an excel file. The aim of the work is to separate my data into different boxes using VBScript(from box 1 to 8)in order to have different data channels (for example:the animals of box 8, the animals of box 6, the consumptions of box 5...)
I thought about using "if...then..." Sentences and "CHD" or "CHDX" variables instead of using "DataBlClpCopy". But I can't get my way.
When I tried to use "DataBlClpCopy" I found the trouble that I had to say the starting row number in the channel and the number of channel values to copy. The problem is that each excel file will have different row numbers and different values to copy.
Does anyone have any idea?

Thank you

[Aaron B.]

Hello,

The solution to the situation is to programmatically parse the data to dynamically determine what rows correspond to which boxes. I have taken the liberty of writing a VB script for you to use that will do just that. For each box, it creates a new group with the same channel names and populates them with the data for just that box. Take care!

Regards,

Aaron B.
National Instruments