View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
bigdaddy3 bigdaddy3 is offline
external usenet poster
 
Posts: 23
Default Accessing excel 2003 from visual studio express edition


-- can someone assist i am trying to access excel 2003 from Visual Studio
Express 2005 express i am using the code below which opens excel but then
gives me an error of com exception was unhandled and highlights the code line
" owb= oxl.workbooks.add", any ideas.


Public Class Form1

Public Sub New()

' This call is required by the Windows Form Designer.
InitializeComponent()

' Add any initialization after the InitializeComponent() call.

End Sub


Private Sub Button1_Click(ByVal sender As System.Object, _
ByVal e As System.EventArgs) Handles Button1.Click
Dim oXL As Excel.Application
Dim oWB As Excel.Workbook
Dim oSheet As Excel.Worksheet
Dim oRng As Excel.Range

' Start Excel and get Application object.
oXL = CreateObject("Excel.Application")
oXL.Visible = True

' Get a new workbook.
oWB = oXL.Workbooks.Add
oSheet = oWB.ActiveSheet

' Make sure Excel is visible and give the user control
' of Excel's lifetime.
oXL.Visible = True
oXL.UserControl = True

' Make sure that you release object references.
oRng = Nothing
oSheet = Nothing
oWB = Nothing
oXL.Quit()
oXL = Nothing

Exit Sub
Err_Handler:
MsgBox(Err.Description, vbCritical, "Error: " & Err.Number)
End Sub





End Class


BD3