I have a script which loads a Numbers document in order to retrieve a specific cell value to use in creating a reminder.
My code is below. I believe I'm using correct syntax to load the value into a variable, but I'm just getting a
0 in the reminder and the dialog doesn't show.
set transferValue to 0 tell application "Numbers" activate try open filePath tell sheet "Monthy Expected" tell table "Account Budget Share" set transferValue to value of cell "B4" display dialog value of cell "B4" display dialog transferValue end tell end tell on error end try end tell
Is there something wrong with what I have done? The correct file is opened when I run the script, but none of the subsequent commands seem to execute. It just opens the document and then continues on to the reminders.