You can save with a password and say .T. to lReadOnlyRecommented
oWorkBook.SaveAs(cFileName,cFileFormat,cPassword,cWriteResPassword,lReadOnlyRecommented)
>Hi, i use CREATEOBJECT to modity a EXCEL.
>how can i call up the PROTECT function in worksheet (file), that can
>not allow any user to modity my file (output).
>
>That is my part of program about call up the EXCEL file.
>
>*****
>OEXCEL = CREATEOBJECT("EXCEL.APPLICATION")
>OEXCEL.SHEETSINNEWWORKBOOK = 1
>OWORKBOOK = OEXCEL.WORKBOOKS.OPEN(MYFILE)
>OACTIVESHEET = OEXCEL.ACTIVESHEET
>OEXCELAPP = OEXCEL.APPLICATION
>WITH OEXCEL
> .CELLS(7,5).VALUE= "Document no : 12345"
>ENDWITH
>OWORKBOOK.SAVE()
>OWORKBOOK.CLOSE()
>OEXCEL.QUIT()
>*****
