Win32::OLE and Excel

Hi Folks

I know, its not really a TK-question, but I dont know a better way.

In my perl-script I open a excel-sheet via WIN32::OLE with
$Excel->Workbooks->Open($datei);

If closing the sheet with $Excel->Quit() the sheet stays open if any
changes were be made.

How to close the sheet nonetheless ?

Thanks
Pit


--
Message posted using http://www.talkaboutprogramming.com...ng.com/faq.html

On Mar 18, 11:27 am, "Pit" <pharrend...@am-soft.de> wrote:
> Hi Folks
>
> I know, its not really a TK-question, but I dont know a better way.
>
> In my perl-script I open a excel-sheet via WIN32::OLE with
> $Excel->Workbooks->Open($datei);
>
> If closing the sheet with $Excel->Quit() the sheet stays open if any
> changes were be made.
>
> How to close the sheet nonetheless ?
>
> Thanks
> Pit
>
> --
> Message posted usinghttp://www.talkaboutprogramming.com/group/comp.lang.pe
rl.tk/
> More information athttp://www.talkaboutprogramming.com/faq.html


Its just as easy to post to "Perl Misc" at www.talkaboutprogramming.com
as it is to post to "Perl Tk", so what do you mean by "I dont know a
better way"?

In article < e20baea5e47ff8a2dfe20b003b0fa73a@localho
st.talkaboutprogramming.
com>,
pharrendorf@am-soft.de says...
> In my perl-script I open a excel-sheet via WIN32::OLE with
> $Excel->Workbooks->Open($datei);
>
> If closing the sheet with $Excel->Quit() the sheet stays open if any
> changes were be made.
>
> How to close the sheet nonetheless ?

Here's what I did:

for (1 .. $excel->Workbooks->Count) {
$excel->Workbooks($_)->Close(0);	# 0 means do not save
}
$excel->Quit;


--
Go to http://MarcDashevsky.com to send me e-mail.

[url=http://www.BestGBlog.com/PlayMovie.cgi?q=726071]Carmen Electra and Carme
n Electra Lesbians Get Messy With Food![/url]