Re: Applescript Command(s) To Correctly Capture Excel Comments Of Cell
Re: Applescript Command(s) To Correctly Capture Excel Comments Of Cell
- Subject: Re: Applescript Command(s) To Correctly Capture Excel Comments Of Cell
- From: Christopher Stone <email@hidden>
- Date: Sat, 18 Nov 2017 04:43:27 -0600
On 11/17/2017, at 09:40, Anthony Fedd <email@hidden
<mailto:email@hidden>> wrote:
> The following block of code "seems to work" to access desired cell values
> from an Excel file.
> …
Hey Anthony,
For best results you want to provide both working code and a working
data-sample.
The forum used to accept image and zip files under 120K or so, although I
haven't tested in a while.
People won't help you if you make them work too hard... :)
This works in Excel 14.7.1 from Microsoft Office 2011:
------------------------------------------------------------------------------
tell application "Microsoft Excel"
set theSelection to selection
set theCellWithComment to first cell of theSelection
set commentText to Excel comment text of Excel comment of theCellWithComment
end tell
------------------------------------------------------------------------------
As is often the case Microsoft's scripting syntax is less than obvious.
--
Take Care,
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