|
改成保护工作表密码,可是手动不能解除,不知是何原因?
Const WINDOW_HANDLE = 0
Const OPTIONS = 0
Dim objShell,objFolder,FolderPath,PassWord,wk,EAPP,FSO,FSOFolder,FSOFile,sht,mySheet,Worksheets,Sheets,Protect,Name
'获取Excel文件所在文件夹路径
Set objShell = CreateObject("Shell.Application")
Set objFolder = objShell.BrowseForFolder(WINDOW_HANDLE, "Select a folder:", OPTIONS,"")
If objFolder Is Nothing Then
Wscript.Quit
End If
FolderPath =objFolder.Self.Path
PassWord=Inputbox("请输入密码","批量添加密码")
if len(password)=0 then Wscript.Quit
Set EAPP=CreateObject("Excel.Application")
Set FSO=CreateObject("Scripting.FileSystemObject")
Set FSOFolder=FSO.GetFolder(FolderPath)
For Each FSOFile in FSOFolder.Files
If instr(Fsofile.Name,".xls") then
Set wk=EAPP.Workbooks.Open(FSOFile)
For Each sht in wk.Worksheets
mySheet = sht.Name
wk.Sheets(mySheet).Protect PassWord=PassWord
Next
wk.Close True
End If
EAPP.Quit
Next
|
|