asp给excel文件设置密码

asp给excel文件设置密码,保护excel文件

set objExcelApp = CreateObject("Excel.Application")
objExcelApp.DisplayAlerts = false 
objExcelApp.Application.Visible = false
objExcelApp.WorkBooks.Open("d:\2.xls")
set objExcelBook = objExcelApp.ActiveWorkBook
set objExcelSheets = objExcelBook.Worksheets
set objExcelSheet = objExcelBook.Sheets(1)
objExcelSheet.Protect("zcb" )

来源:http://club.excelhome.net/thread-220350-1-1.html

加支付宝好友偷能量挖...


评论(0)网络
阅读(146)喜欢(1)Asp/VBScript