2011年計(jì)算機(jī)等級(jí)二級(jí)VB輔導(dǎo)知識(shí)技巧總結(jié)(26)(8)

字號(hào):

xlCheckApp.Quit
    CheckExcel = True
    Set xlCheckApp = Nothing
    End If
    End Function
    Function CreateWorkBook(ByVal strWorkBook As String, xlApp As Excel.Application)
    Dim xlCreateWorkBook As Excel.Workbook
    Set xlCreateWorkBook = xlApp.Workbooks.Add
    xlCreateWorkBook.SaveAs (strWorkBook)
    End Function
    Function GetPath(strPath As String) As String
    GetPath = IIf(Len(strPath) = 3, strPath, strPath & “\”)
    End Function
    這上面的函數(shù)只不過(guò)是一部分,其于的因?yàn)閷S媚康?,寫不?biāo)準(zhǔn),以后也許會(huì)整理出來(lái)一份標(biāo)準(zhǔn)的函數(shù)庫(kù)的!