daniel50096230
Member
- Joined
- Jan 5, 2009
- Messages
- 8
- Programming Experience
- Beginner
Hi, I had the following code:
I am trying to call EntFunc2.xla and load it into the Excel1.xls but it seems like not successful. May I know how can I really run the xla file in my Excel directly through VB.NET codes?
VB.NET:
Dim xlApp As Excel.Application = Nothing
Dim xlWorkBooks As Excel.Workbooks = Nothing
Dim xlWorkBook As Excel.Workbook = Nothing
Dim xlCells As Excel.Range = Nothing
xlApp = New Excel.Application
xlApp.DisplayAlerts = False
xlWorkBooks = xlApp.Workbooks
xlWorkBook = xlWorkBooks.Open("C:\Excel1.xls")
xlApp.Visible = True
xlApp.Run("P:\MASTER\EntFunc2.xla")
I am trying to call EntFunc2.xla and load it into the Excel1.xls but it seems like not successful. May I know how can I really run the xla file in my Excel directly through VB.NET codes?