vb 利用Excel.Application对象,怎么给表格设置密码
注意,重点是设置密码,是设置新的密码,最好还能修改密码,
有这两种的,加分,麻烦帮忙
vbéæä¹å..ä¸æ¯è¦å®ä»£ç ...
追çä½ è¦éè¿vbæ¥æ§å¶excelï¼ä¸æ¯ç¨excelä¸çvbaï¼
ä½ è¯ä¸ä¸æ以ä¸éå¾ï¼
å
å¨å·¥ç¨ä¸å¼ç¨(çµèéå¿
é¡»å®è£
officeçexcel)
å¼ç¨ miscrosoft excel 11.0 object library
ç¶åå¯ä»¥å代ç ï¼
Private Sub Command1_Click()
Dim xlApp As Excel.Application
Dim xlBook As Excel.Workbook
Dim xlSheet As Excel.Worksheet
Set xlApp = CreateObject("Excel.Application") 'å建EXCELåºç¨ç±»
Set xlBook = xlApp.Workbooks.Add 'æ·»å ä¸ä¸ªæ°çBOOK
Set xlSheet = xlBook.Worksheets(1) 'æä½ä¸ä¸ªSHEET
xlSheet.Protect "123" '设置å¯ç
xlSheet.Unprotect "123" â解é¤å¯ç
ââ¦â¦â¦â¦è¦ä»ä¹æä½ç±»ä¼¼æ·»å
xlBook.SaveAs ("c:\1.xls") 'ä¿åæ件
Set xlSheet = Nothing 'éæ¾å¯¹è±¡
xlBook.Close
Set xlBook = Nothing
xlApp.Quit
Set xlApp = Nothing
End Sub
è¯è¯å§ï¼æè¿é没ævb6.0ç¨åºï¼æ²¡ææµè¯è¿ã