Excel Save & Cell Protectby Anonymous Monk
|on Sep 11, 2003 at 08:23 UTC||Need Help??|
Anonymous Monk has asked for the
wisdom of the Perl Monks concerning the following question:
Answers to either of the following will be much appreciated.
I want to overwrite an existing Excel spreadsheet without being asked the question 'Do I really want to do this'. I could delete the file before overwriting but I wondered if there was an option for the $excel->Workbooks(1)->SaveAs(filename)that allowed this.
I want to protect cells of an Excel spreadsheet that I create so that when using Excel to read the spreadsheet these cells cannot be modified. How can this be done?