468,491 Members | 1,952 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,491 developers. It's quick & easy.

Open Excel doc from vb.net

How can I open an Excel Document from vb.net

Thank
Gary
Nov 20 '05 #1
4 3478
Ian
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" <an*******@discussions.microsoft.com> wrote in message
news:2F**********************************@microsof t.com...
How can I open an Excel Document from vb.net?

Thanks
Gary

Nov 20 '05 #2
Cor
Hi Gary,

I think you find it here

Office
http://support.microsoft.com/default...b;EN-US;311452

or there

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

I hope this helps?

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

\
Nov 20 '05 #3
On Wed, 3 Mar 2004 06:16:09 -0800, "Gary" <an*******@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...&Product=vbNET
Paul ~~~ pc******@ameritech.net
Microsoft MVP (Visual Basic)
Nov 20 '05 #4
* "=?Utf-8?B?R2FyeQ==?=" <an*******@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>

Other HOWTO articles on Excel + VB.NET:

<http://support.microsoft.com/common/canned.aspx?R=d&H=Visual%20Basic%20.NET%20How%20To %20Articles&LL=kbvbnetSearch&SZ=kbhowtomaster>

--
Herfried K. Wagner [MVP]
<http://dotnet.mvps.org/>
Nov 20 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

13 posts views Thread by Allison Bailey | last post: by
3 posts views Thread by Jennyfer Barco | last post: by
6 posts views Thread by Michael Groeger | last post: by
7 posts views Thread by Peter | last post: by
reply views Thread by NPC403 | last post: by
3 posts views Thread by gieforce | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.