excel ole readonly open

Discussion in 'Perl Misc' started by liefje@gmail.com, Jun 26, 2006.

  1. Guest

    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.
     
    , Jun 26, 2006
    #1
    1. Advertising

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Patrick.O.Ige

    Ole ole

    Patrick.O.Ige, Jul 16, 2006, in forum: ASP .Net
    Replies:
    0
    Views:
    501
    Patrick.O.Ige
    Jul 16, 2006
  2. Drew Pihera
    Replies:
    0
    Views:
    649
    Drew Pihera
    Feb 4, 2004
  3. Jonathan Hyatt
    Replies:
    1
    Views:
    1,949
    Jonathan Hyatt
    Jun 8, 2004
  4. Replies:
    1
    Views:
    833
  5. TimmyD
    Replies:
    0
    Views:
    181
    TimmyD
    Apr 21, 2005
Loading...

Share This Page