Re: beginner's Excel script (round2)
Re: beginner's Excel script (round2)
- Subject: Re: beginner's Excel script (round2)
- From: Paul Berkowitz <email@hidden>
- Date: Sun, 28 Mar 2004 17:57:41 -0800
On 3/28/04 5:43 PM, "Bill Metzinger" <email@hidden> wrote:
>
>
set myVar to read file (((path to desktop folder) as text) & "mytxt")
>
as string
>
tell application "Microsoft Excel"
>
Create New Workbook
>
set r to 7
>
repeat with l from 1 to count items of myVar
>
set Formula of Cell ("R" & r & "C3") to item l of myVar
>
set r to r + 1
>
end repeat
>
end tell
Did you forget perhaps to
set myVar to paragraphs of myVar
? or something like that? Without specifying a delimiter - be it paragraph
ends or tabs or _something_ - 'items of myVar' are going to be each and
every character of the text file. Not what you want, I don't think.
I now can't recall the original problem posed, but I'm also curious as to
why you would put 7 formulas into a text file instead of just into a lost
variable. Or was that specified in the original question?
--
Paul Berkowitz
[demime 0.98b removed an attachment of type application/pkcs7-signature which had a name of smime.p7s]
_______________________________________________
applescript-users mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/applescript-users
Do not post admin requests to the list. They will be ignored.