excel ole readonly open

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,744
Messages
2,569,483
Members
44,901
Latest member
Noble71S45

Latest Threads

Top