Re: Creating TextBox in Excel
Re: Creating TextBox in Excel
- Subject: Re: Creating TextBox in Excel
- From: David Wignall <email@hidden>
- Date: Fri, 13 Sep 2002 08:40:57 +1200
on 12/9/2002 9:50 AM, Jay Young at email@hidden wrote:
>
I was wondering if it's possible to create a text box (from the
>
'Drawing' toolbar) in an Excel worksheet. I have found the term
>
'Textbox' in the Excel Dictionary but I can't figure out the syntax to
>
add a new text box into a worksheet and then fill it with text.
on 12/9/2002 3:23 PM, Jay Young at email@hidden wrote:
>
So far, I still can't figure out how to create the Text box though.
>
Here's some code I've been working with (it gives me a 'Can't continue
>
Create' error):
>
>
tell application "Microsoft Excel"
>
Activate
>
Create New TextBox At ActiveSheet With Properties {Top:100, Left:200,
>
Height:40, Width:40}
>
end tell
Create is Excel terminology, which doesn't appear to work. From Smile I get
a "doesn't understand" message. Make new TextBox doesn't work either; "can't
make a Textbox." In fact I don't seem able to create any new drawing object
in Excel X nor... <checking>... Excel 2001 although I can refer to existing
ones. Those terms may be depreciated? How annoying. You may have to call a
VBA procedure.
--
fwiw
Dave
_______________________________________________
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.