Launch Excel spreadsheet using journal
Launch Excel spreadsheet using journal
(OP)
Is there a way to open an excel spreadsheet from a VB.net journal without having to specify the executable path for the excel program (i.e. I just want to open a workbook from a journal without knowing where the excel exe is stored)?
Thanks.
Thanks.





RE: Launch Excel spreadsheet using journal
Public xlApp As Excel.Application
Public xlBook As Excel.Workbook
Public xlSheet As Excel.Worksheet
' open the Excel template
xlApp = CType(CreateObject("Excel.Application"), Excel.Application)
xlBook = xlApp.Workbooks.Open(templteData, 0, True, 5, "", "", True, Excel.XlPlatform.xlWindows, "\t", False, False, 0, True)
xlSheet = xlBook.Worksheets(1)
xlSheet.Application.Visible = True