開啟 Excel File
程式法範例如下:
Dim WB1 As Workbook
Workbooks.Open Filename:="C:\Documents and Settings\twn040701\桌面\現行產品設計值一覽表Ver.16.xls", UpdateLinks:=False, ReadOnly:=True
Set WB1 = ActiveWorkbook
程式法範例如下:
Dim WB1 As Workbook
Workbooks.Open Filename:="C:\Documents and Settings\twn040701\桌面\現行產品設計值一覽表Ver.16.xls", UpdateLinks:=False, ReadOnly:=True
Set WB1 = ActiveWorkbook