«

i would like to open an xls file in read only mode so i dont have to
say 'no' to the dialog box saying 'do you want to save the changes?'
everytime the script opens the file and closes it. i have tried using
this:

my $Book = $Excel->Workbooks->Open({
FileName => 'i:\tmp\ole\test.xls',
ReadOnly => 1 });

and this:

my $Book = $Excel->Workbooks->Open('i:\tmp\ole\test.xls', 0, 1);

i have also tried setting readonly for the file attributes!

nothing seems to work, its always asking me if i want to save changes
that didnt even happen in the first place.