VB.NET自动加载.xla文件
Public Function Loadxla(ByVal xlaPath As String, ByVal load As Boolean) As Boolean
Dim loaded As Boolean = False
Try
If (File.Exists(xlaPath)) Then
Dim o As Object
o = XlApp.AddIns.Add(xlaPath, True) '定义成object,add by danielinbiti
o.Installed = load
loaded = o.Installed
End If
Catch
loaded = False
End Try
Loadxla = loaded
End Function
调用如
Loadxla("E:\selfh.xla", True)
Xlapp为Excel.Application对象