RunTextAsMacro: cannot create new item: text is too long

[Gintaras]

Save the worksheet as tab-delimited text file "file1.txt" on desktop. This macro will get data from that file, and repeat for each line.

Code:

Copy      Help

str sf.getfile("$desktop$\file1.txt")
str s s1 s2 s3
foreach s sf
,tok s &s1 3 "[9]"
,key (s1) T (s2) T (s3)
,1
,key F9
,1
,key F9
,1