·一周点击排行
·热点推荐
如何用程序实现链接有“打开密码”的EXCEL表
发布时间：2008-5-28 15:25:00 浏览次数: 256
方法1:
MyXL.Workbooks.Open Filename:=strFileName, Password:=strPassword
方法2:
Dim oExcel As Excel.Application
Dim oBook As Excel.Workbook
Set oExcel = New Excel.Application
oExcel.Visible = True
Set oBook = oExcel.Workbooks.Open _
(FileName:="C:\Test\xxx.xls", _
ReadOnly:=True, _
Password:="secret")
Set oBook = Nothing
Set oExcel = Nothing
讨论此主题请进>>: 如何用程序实现链接有“打开密码”的EXCEL表