?? toexcel.bas
字號:
Attribute VB_Name = "toExcel"
'Download by http://www.codefans.net
Public xlApp As Excel.Application '定義EXCEL類
Public xlBook As Excel.Workbook '定義工件簿類
Public xlsheet As Excel.Worksheet '定義工作表類
Public Sub openXLT(ByVal xltName As String) '打開EXCEL過程
Set xlApp = CreateObject("Excel.Application") '創建EXCEL應用類
Set xlBook = xlApp.Workbooks.Open(App.Path & "\xlt\" & xltName) '打開EXCEL工作簿
Set xlsheet = xlBook.Worksheets(1) '打開EXCEL工作表
End Sub
Public Sub closeXLT()
xlApp.Visible = True '設置EXCEL可見
Set xlApp = Nothing '釋放EXCEL對象
End Sub
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -