I dont have Outlook on this machine, so I cant test it, but my guess is that
youre probably dealing with an OLE Variant datatype. Read the
Win32::OLE::Variant documentation and see if that gets you anywhere.
Sometimes just adding 'use Win32::OLE::Variant' at the top of the script
will make it
I havent ever used the excel OLE control, but I assume this will work (it
does in other similar situations):
if(defined($sheet-Range(FRED))) {
# Cell is defined
$sheet-Range(FRED)-{Value} = foo;
} else {
# Cell isnt defined, throw an error
die(Cell \FRED\ isn't defined!!);
}
HTH - Matt