Hey Mike,
You just want the value of cell A1? If that's not all then please be more specific.
tell application "Microsoft Excel"
tell active sheet of active workbook
set cellAOneValue to value of cell "A1"
end tell
end tell
It's a good idea to mention what data you're collecting as well, since there are a few pitfalls when dealing with certain data-types.
For what? AppleScript in general? AppleScripting Microsoft Excel?
There's not a single great source.
- MacScripter.net
- Script Debugger Forum
- Learning and Developing AppleScripts
- Learning & Using AppleScript & JavaScript for Automation (JXA)
Run, don't walk and buy a copy of Script Debugger, or at the very least download and use the free (Lite) version instead of Apple's horribly anemic Script Editor app. (Even the Lite version of SD eats the SE's lunch.)
-Chris