Excel Export

I am trying to feed values into a VB component which then exports it to excel.
The code which I got from this forum works in so far as being able to export to excel
when I generate the x,y,z values within the code but when I try to feed values into
the component, it does not seem to want to accept the numbers.

Many thanks