Keep It Simple, Stupid | |
PerlMonks |
Re: save read-only Excelby sundialsvc4 (Abbot) |
on Jun 23, 2015 at 18:37 UTC ( [id://1131702]=note: print w/replies, xml ) | Need Help?? |
What am I missing here? If the Excel file is “read only,” then naturally Windows will not allow it to be replaced. It will insist that the file must be saved under a different name. And, yes, it just might “pop up a user prompt” in that case. Your program, therefore (and regardless of language) must detect that the file is read-only ... OLE will tell you ... and “save as” in that case, thereby avoiding any prompt.
In Section
Seekers of Perl Wisdom
|
|