How to open excel applicatiion using VB.NET?

studio

#1

how to open excel using VB.NET? by using invoke code activity?


#2

Hi,

Use open application activity and indicate an excel file when it is open and so the file name property and selector for open application activity will be set automatically.Capture

1


#3

Hi @vijai1,

use the Below code using Invoke code sctivity

 Dim xlsApp As Excel.Application = Nothing
        Dim xlsWorkBooks As Excel.Workbooks = Nothing
        Dim xlsWB As Excel.Workbook = Nothing

        xlsApp = New Excel.Application
        xlsApp.Visible = True
        xlsWorkBooks = xlsApp.Workbooks
        xlsWB = xlsWorkbooks.Open("strExcelFilePath")

Regards,
Arivu


#4

hi arivu,

i have got this. but we need to add a few more lines in xaml file as it is not recognizing the code.