how to make application work with excel  
Author Message
A.F.B





PostPosted: Visual Basic Express Edition, how to make application work with excel Top

Hello,

I am not sure if this is the right group to ask this question. I need to make my app work with excel. I have managed to get it working with access and add an analysing and charting functionality of excel. Can anybody recommend good resource on how to approach this Do I need to use VSTO I am using vb express(can't afford the paid versions yet...). Is it not good enough

Thank you for any help rendered



Visual Studio Express Editions5  
 
 
DMan1





PostPosted: Visual Basic Express Edition, how to make application work with excel Top

You do not need to use VSTO...You will however have to make a project level reference to the Excel Library (which means you will and your application users will have to have excel installed on thier machine)

Hopefully this will get you started:

Imports Excel = Microsoft.Office.Interop.Excel

Public Class Form1

Private Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click

Dim XL As New Excel.Application

XL.Visible = True

XL.WindowState = Excel.XlWindowState.xlMaximized

Dim XLWB As Excel.Workbook = XL.Workbooks.Open("C:\Myworkbook.xls")

Dim xlSh As Excel.Worksheet = CType(XLWB.Worksheets(1), Excel.Worksheet)

....

End Sub



 
 
A.F.B





PostPosted: Visual Basic Express Edition, how to make application work with excel Top

Thanks DMan1. btw, can you give some suggestions/reference on the rest of the stuff like the excel maths and charting engine I would like to make those excel functionalities accesible to my app as well.

Thanks in advance.


 
 
DMan1





PostPosted: Visual Basic Express Edition, how to make application work with excel Top

for information on developing using excel...check out the excel developer center:

http://msdn.microsoft.com/office/program/excel/default.aspx