Question with Macros In Excel

dudydude has asked for the wisdom of the Perl Monks concerning the following question:

Hi fellow monks, I have a quick question:

How can I close Excel Workbook without it asking me if I want to save changes? I just want to close it, doesn't matter if this saves the changes or not...

This is part of my code: $Book -> Close;

Comment on Question with Macros In Excel

Replies are listed 'Best First'.
Re: Question with Macros In Excel by davies (Monsignor) on Jul 11, 2011 at 21:57 UTC
Untested: `$xl->{DisplayAlerts}=0;`. You will need to use the appropriate reference to your Excel instance instead of $xl. Regards, John Davies	[reply] [d/l]
Re^2: Question with Macros In Excel by dudydude (Novice) on Jul 11, 2011 at 22:37 UTC
It worked! Thank you very much! :)	[reply]