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. Advertisements

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. Luis Esteban Valencia

    1000 pts datagrid to excel with columns readonly

    Luis Esteban Valencia, Jan 7, 2005, in forum: ASP .Net
    Replies:
    1
    Views:
    682
    Raterus
    Jan 7, 2005
  2. Patrick.O.Ige

    Ole ole

    Patrick.O.Ige, Jul 16, 2006, in forum: ASP .Net
    Replies:
    0
    Views:
    703
    Patrick.O.Ige
    Jul 16, 2006
  3. Drew Pihera
    Replies:
    0
    Views:
    912
    Drew Pihera
    Feb 4, 2004
  4. =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?=

    Problem with Excel reports ::::Excel 2003 Migration To Excel 2007

    =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?=, Oct 5, 2007, in forum: ASP .Net
    Replies:
    15
    Views:
    2,006
    =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?=
    Oct 24, 2007
  5. Jonathan Hyatt
    Replies:
    1
    Views:
    3,026
    Jonathan Hyatt
    Jun 8, 2004
  6. Lance Hoffmeyer
    Replies:
    0
    Views:
    536
    Lance Hoffmeyer
    Nov 17, 2003
  7. Replies:
    1
    Views:
    1,298
  8. TimmyD
    Replies:
    0
    Views:
    314
    TimmyD
    Apr 21, 2005
Loading...