Re: Read a cell in Excel 2004
Re: Read a cell in Excel 2004
- Subject: Re: Read a cell in Excel 2004
- From: Nan Mossey <email@hidden>
- Date: Wed, 10 Nov 2004 13:54:34 -0500
Short date string was the answer! Thank you!
If you ca help me with one last question, I'll be done with this and can get
on to my real life. When I try to get the value of a cell whose number
format is set to currency, my result shows up as "missing value". Any fixes
for this? I'm much indebted.
On 11/10/04 1:03 PM, "Paul Berkowitz" <email@hidden> wrote:
> Yes.
>
> tell app "Microsoft Excel"
> set Pubdate to value of cell "B3"
> end tell
>
> set Pubdate to date string of Pubdate
> --> "Thursday, November 4, 2004"
>
> --in OS 10.3:
> set Pubdate to short date string of Pubdate
> --> "11/4/04" -- in whatever format you have set in International System
> Preferences/Format
>
>
>
> If you need the leading zeroes for month and day ("11/04/04"), you'll need
> to set that format in International System Preferences/Format/Short Date.
>
> Or you can use a subroutine of your own (I can give you one), which will
> also work in OS 10.2, to get a short date string of your choosing from
> dates.
--
Nan Mossey
Times Union Publications Manager
1 News Plaza
Albany NY 12212
518-454-5704
========================================================
This e-mail message is intended only for the personal
use of the recipient(s) named above. If you are not
an intended recipient, you may not review, copy or
distribute this message.
If you have received this communication in error,
please notify the Albany Times Union Help Desk
(email@hidden) immediately by e-mail and
delete the original message.
========================================================
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Applescript-users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden