Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.

Dismiss

Open Excel doc from vb.net

8 views

Skip to first unread message

Ian

unread,

Mar 3, 2004, 9:44:15 AM3/3/04

Open your vb.net project and create a COM reference to Microsoft Excel 9.0
Object Library

use the following code

Dim ExcelApp As New Excel.ApplicationClass

ExcelApp.Visible = True
ExcelApp.Workbooks.Open("C:\Book1.xls")

"Gary" <anon...@discussions.microsoft.com> wrote in message
news:2FD7AD2D-F0DD-4AA0...@microsoft.com...
> How can I open an Excel Document from vb.net?
>
> Thanks
> Gary

Cor

unread,

Mar 3, 2004, 9:41:44 AM3/3/04

Hi Gary,

I think you find it here

Office
http://support.microsoft.com/default.aspx?scid=kb;EN-US;311452

or there

http://msdn.microsoft.com/office/

I hope this helps?

Cor

Paul Clement

unread,

Mar 3, 2004, 10:22:07 AM3/3/04

On Wed, 3 Mar 2004 06:16:09 -0800, "Gary" <anon...@discussions.microsoft.com> wrote:

¤ How can I open an Excel Document from vb.net?

Plenty of articles out there:

HOWTO: Automate Microsoft Excel from Visual Basic .NET
http://support.microsoft.com/default.aspx?scid=kb;en-us;301982&Product=vbNET

Paul ~~~ pcle...@ameritech.net
Microsoft MVP (Visual Basic)

Herfried K. Wagner [MVP]

unread,

Mar 3, 2004, 11:27:05 AM3/3/04

* "=?Utf-8?B?R2FyeQ==?=" <anon...@discussions.microsoft.com> scripsit:

> How can I open an Excel Document from vb.net?

HOWTO: Automate Microsoft Excel from Visual Basic .NET
<http://support.microsoft.com/default.aspx?scid=kb;en-us;301982>