data to excel

[Ken Ray]

On Mon, 12 Feb 2007 21:08:18 +0000, Liam Lambert wrote:

> I am trying to enter some data into excel using Ken Ray's code.
> I want to put the data into columns  A1,B1  (the number for each row 
> is entered in field "Nub")
> 
> 
> ON mouseUp
>     put "A,B,C,D,E" INTO tAlph
>     REPEAT for each item tLett in tAlph
>     put tLett before fld "Nub"
>     put fld "Nub" into tNub
>      SendToXL "99",tNub
>     delete char 1 of fld "Nub"
>     END REPEAT
> END mouseUp

Can you try something like this (doesn't use the field so much):

on mouseUp
  put "A,B,C,D,E" into tAlph
  put fld "Nub" into tNub
  repeat for each item tLett in tAlph
    SendToXL "99",(tLett & tNub)
  end repeat
end mouseUp

Works here...




Ken Ray
Sons of Thunder Software, Inc.
Email: kray at sonsothunder.com
Web Site: http://www.sonsothunder.com/