Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > Perl > Perl Misc > excel ole readonly open

Thread Tools

excel ole readonly open
Posts: n/a
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

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.

Reply With Quote

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Ole ole Patrick.O.Ige ASP .Net 0 07-16-2006 08:10 AM
OLE & Excel - Opening causes Excel.exe to hang around TimmyD Perl Misc 0 04-21-2005 07:20 PM
Win32::OLE Excel Chart SeriesCollection. Problem changing from Excel 2000 to 2002 Perl Misc 1 07-05-2004 10:50 AM
ASP.NET Readonly panel function with readonly checkbox, readonly radiobutton Jonathan Hyatt ASP .Net Web Controls 1 06-08-2004 07:42 PM
Creating an OLE server document in Python (MFC/OLE/COM/Python newbie) Drew Pihera Python 0 02-04-2004 07:48 PM