如何用程序实现链接有“打开密码”的EXCEL表格
1:
myxl . workbooks . open filename:= str filename,password: = strpassword
方法2:
dim o excel as excel . application
dim book as excel . workbook
set o excel = new excel . application
o excel . visible = true
设置oBook = oExcel。Workbooks.Open _
(文件名:="C:\Test\xxx.xls ",_
ReadOnly:=True,_
密码:="secret ")
Set oBook = Nothing
Set OE xcel = Nothing
0条评论