L
liefje
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.
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.