[MacPerl] AppleScript & Excel

[Yosemite <g3pb@alaska.net>]

Title: AppleScript & Excel

the following script will not set the value of cell A1 in Excel when run from MacPerl, the errNum from AppleScript is -10006, cant set obj/data to obj/data. The AppleScript portion does function properly when run as an AppleScript. What can I do to have this run from MacPerl?

#!perl

$script = <<EOS;
try
    tell application "Microsoft Excel"
        set Value of Cell "$A$1" to "1"
    end tell
on error errMsg number errNum
    display dialog errNum
end try
EOS
print MacPerl::DoAppleScript($script) or
    die("Error running AppleScript");
print "\ndone.";


--  hcir
mailto:g3pb@alaska.net