Unanswered: Protect Excel sheet, after creating/opening thru the .asp/Java script.
I am generating Excel Report output using .asp.
I am opening one existing .xls template. I am inserting data and picture in to cells. At last, I am using 'Saveas' other name.
So, all content of .xls sheet will be stored under new .xls file name. Now, I am showing this new .xls filereport in another window of .asp.
But this .xls file under browser is not protected. One can delete content or copy content(picture of signature).
So, I want to do one of this things.
1. Protect .xls sheet for delete/copy content of any cell in it.
2. I want to stop 'Right click event' and 'certain menu option' in excel sheet opened in new Window.
3. I want to open .xls in window in such a mode so, user can not copy any content from it.
Set ExcelApp = CreateObject("Excel.Application")
ExcelApp.Application.Visible = True
' Close all pending books
'Open the template
Set ExcelBook = ExcelApp.Workbooks.Open("C:\Inetpub\iissamples\te\ TE_Supplement_Template.XLS", , True)
lsFullFileName = "C:\Inetpub\iissamples\te\TE_Supplement_Template2. XLS"
Set oFS = CreateObject("Scripting.FileSystemObject")
if (oFs.FileExists(lsFullFileName) = TRUE) then
''''''assiging data stuff to cells.
Set ExcelApp = Nothing
I have used following to open this file from Java script.