in reply to save read-only Excel
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.