Re: Defining an excel function with applescript
Re: Defining an excel function with applescript
- Subject: Re: Defining an excel function with applescript
- From: Eric C Saunders <email@hidden>
- Date: Tue, 14 Oct 2008 13:23:38 -0400
Steen Knudsen wrote on 10/14/2008 at 01:08:50 PM:
> When using excel on windows I have been able to apply a function by
> the use of Visual Basic.
> The function enables me to get the reverse of a text string in one
> cell - e.g. "ABCDEFG" -> "GFEDCBA"
>
> I am now using Excel 2008 12.1.2 on Mac. But I would still like to
> be able to use this function. Can I define this function by using
> Apple Script?
>
> If it is possible, how do I do it?
tell application
"Microsoft Excel"
set
foo to
value of
cell "A1"
end tell
set foo to
(reverse of
(characters of
(foo as
string))) as
string
return foo
>
> Thanks in advance for your help
>
> Steen Knudsen
>
You are welcome ( I hope this helps)
Eric Saunders
This electronic message contains information from MeadWestvaco Corporation or
subsidiary companies, which may be confidential, privileged or otherwise protected
from disclosure. The information is intended to be used solely by the recipient(s)
named. If you are not an intended recipient, be aware that any review, disclosure,
copying, distribution or use of this transmission or its contents is prohibited. If you
have received this transmission in error, please notify MeadWestvaco immediately
at email@hidden.
_______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users
This email sent to email@hidden