SV: Need help: Really silly Excel 2004 question
SV: Need help: Really silly Excel 2004 question
- Subject: SV: Need help: Really silly Excel 2004 question
- From: Richard Rönnbäck <email@hidden>
- Date: Wed, 13 Oct 2004 14:03:44 +0200
Thanks Shane!
Exactly what I was looking for!
I just added a handler to get rid of the "$" so something like this is what
I will do
tell application "Microsoft Excel"
set myUsedRange to used range of sheet 1 of workbook 1
set myCellRefString to (get address local (cell 1 of myUsedRange))
set myCellRefString to my TrimCellRef(myCellRefString)
end tell
on TrimCellRef(myCellRefString)
set AppleScript's text item delimiters to "$"
set myCellRefString to (text item 2 of myCellRefString & text item 3 of
myCellRefString)
set AppleScript's text item delimiters to ""
return myCellRefString
end TrimCellRef
Thanks again
/ Richard
> Från: Shane Stanley <email@hidden>
> Datum: Wed, 13 Oct 2004 21:26:20 +1000
> Till: AppleScript <email@hidden>
> Ämne: Re: Need help: Really silly Excel 2004 question
>
>
> You can get the addresses in "$A$1" format like this:
>
> tell application "Microsoft Excel"
> set myUsedRange to used range of sheet 1 of workbook 1
> get address (cell 1 of myUsedRange) reference style A1
> end tell
>
> Although in your case you might want "get address local" instead.
>
> --
> Shane Stanley <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:
This email sent to email@hidden