• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag
 

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Scope riddle I can't seem to solve. (Probably very easy to solve for an experienced coder)
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Scope riddle I can't seem to solve. (Probably very easy to solve for an experienced coder)


  • Subject: Re: Scope riddle I can't seem to solve. (Probably very easy to solve for an experienced coder)
  • From: Christopher Stone <email@hidden>
  • Date: Fri, 21 Mar 2014 10:52:43 -0500

On Mar 21, 2014, at 10:00, Ted Wrigley <email@hidden> wrote:
Still a scope issue, because you went a little overboard.  :-)  note the following:
______________________________________________________________________

Hey Ted,

Did that code actually work for you?  It fails here.  { Microsoft Excel 14.3.9 on OSX 10.9.2 }

Note the FAIL comments:

-------------------------------------------------------------------------------------------
tell application "Microsoft Excel"
set WB to workbook "TestBook.xlsx" # SUFFIX REQUIRED IN WORKBOOK NAME.


tell WB
set WS1 to sheet "Goofy1"
set WS2 to sheet "Goofy2"
set WS3 to sheet "Goofy3"


get address of active cell # FAIL!


tell WS1
activate # FAIL!
get address of active cell # FAIL!
end tell


end tell
end tell

-------------------------------------------------------------------------------------------

--
Best Regards,
Chris

 _______________________________________________
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

References: 
 >Re: Scope riddle I can't seem to solve. (Probably very easy to solve for an experienced coder) (From: Ted Wrigley <email@hidden>)

  • Prev by Date: Re: Scope riddle I can't seem to solve. (Probably very easy to solve for an experienced coder)
  • Next by Date: Re: Scope riddle I can't seem to solve. (Probably very easy to solve for an experienced coder)
  • Previous by thread: Re: Scope riddle I can't seem to solve. (Probably very easy to solve for an experienced coder)
  • Next by thread: Re: Scope riddle I can't seem to solve. (Probably very easy to solve for an experienced coder)
  • Index(es):
    • Date
    • Thread