Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations MintJulep on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Launch Excel spreadsheet using journal

Status
Not open for further replies.

claforet

Mechanical
Apr 8, 2010
54
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.
 
Replies continue below

Recommended for you

' Declare Excel object variables and create types
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor