.NET and Office applications programming

[Luke Vogel]

Hi all ... could someone point me in the right direction for programming
office applications (specifically excel) using vb.net?

Can vb.net replace or enhance VBA that comes with the office suite?

cheers... have a great Christmas all!
--
Regards Luke.
-----
There are 10 types of people in this world
Those that understand binary and those that don't
-----

[Andy O'Neill]

"Luke Vogel" <not@_real_address> wrote in message
news:OS**************@tk2msftngp13.phx.gbl...

Hi all ... could someone point me in the right direction for programming
office applications (specifically excel) using vb.net?

Can vb.net replace
Yes
or enhance VBA that comes with the office suite?
Umm.... possibly

The reason to use it is (IMO) because you have a dotnet app that needs to do
a bit of office functionality.
Maybe you have a production planning system has a bunch of screens and
crystal reports.
Some user manager then decides they want a dead complex 3d rotating excel
chart.

cheers... have a great Christmas all!
--

Merry christmas.
--
Regards,
Andy O'Neill

[Herfried K. Wagner [MVP]]

Luke,

"Luke Vogel" <not@_real_address> schrieb:

could someone point me in the right direction for programming
office applications (specifically excel) using vb.net?
General:

INFO: Develop Microsoft Office Solutions with Visual Studio .NET
<URL:http://support.microsoft.com/?kbid=311452>

HOWTO: Automate Microsoft Excel from Visual Basic .NET
<URL:http://support.microsoft.com/?scid=kb;EN-US;301982>

How To Use ADO.NET to Retrieve and Modify Records in an Excel Workbook With
Visual Basic .NET
<URL:http://support.microsoft.com/?scid=kb;EN-US;316934>

Samples:

How to handle events for Excel 2003 by using Visual Basic .NET
<URL:http://support.microsoft.com/?scid=kb;EN-US;822750>

HOW TO: Handle Events for Excel by Using Visual Basic .NET
<URL:http://support.microsoft.com/default.aspx?scid=kb;en-us;302814>

HOWTO: Automate Microsoft Excel from Visual Basic .NET
<URL:http://support.microsoft.com/?scid=kb;EN-US;301982>

HOW TO: Transfer Data to an Excel Workbook by Using Visual Basic .NET
<URL:http://support.microsoft.com/?scid=kb;EN-US;306022>

HOW TO: Handle Events for Excel by Using Visual C# .NET
<URL:http://support.microsoft.com/?scid=kb;EN-US;823981>

Related:

BUG: "Old Format or Invalid Type Library" Error When Automating Excel 2002
<URL:http://support.microsoft.com/?scid=kb;EN-US;320369>

PRB: Office Application Does Not Quit After Automation from Visual Studio
..NET Client
<URL:http://support.microsoft.com/?scid=kb;EN-US;317109>

HOWTO: Use the WebBrowser Control to Open an Office Document in Visual Basic
..NET
<URL:http://support.microsoft.com/?scid=kb;EN-US;304643>

INFO: Considerations for Server-Side Automation of Office
<URL:http://support.microsoft.com/?scid=kb;EN-US;257757>

More information:

<URL:http://support.microsoft.com/search/?query=Excel+.NET&catalog=LCID%3D1033>

There are loads of information about how to use Office applications together
with .NET in the Microsoft Office Developer Center:

Microsoft Office Developer Center
<URL:http://msdn.microsoft.com/office/>

Office Development
<URL:http://msdn.microsoft.com/office/understanding/>
Can vb.net replace or enhance VBA that comes with the office suite?

You can write managed Office solutions using VB.NET.

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://dotnet.mvps.org/dotnet/faqs/>

[chanmmn]

Play with the sample code here:

http://msdn.microsoft.com/office/und...l/default.aspx

chanmm

"Luke Vogel" <not@_real_address> wrote in message
news:OS**************@tk2msftngp13.phx.gbl...

Hi all ... could someone point me in the right direction for programming
office applications (specifically excel) using vb.net?

Can vb.net replace or enhance VBA that comes with the office suite?

cheers... have a great Christmas all!
--
Regards Luke.
-----
There are 10 types of people in this world
Those that understand binary and those that don't
-----

[Luke Vogel]

Thank you Herfried and all that responded ... I now have a heap of
reading to do ... but not today!!! It's Christmas here down under in
Australia!!!
Cheers.

Luke.

"Herfried K. Wagner [MVP]" <hi***************@gmx.at> wrote in message
news:uy*************@TK2MSFTNGP15.phx.gbl...

Luke,

"Luke Vogel" <not@_real_address> schrieb:

could someone point me in the right direction for programming
office applications (specifically excel) using vb.net?
General:

INFO: Develop Microsoft Office Solutions with Visual Studio .NET
<URL:http://support.microsoft.com/?kbid=311452>

HOWTO: Automate Microsoft Excel from Visual Basic .NET
<URL:http://support.microsoft.com/?scid=kb;EN-US;301982>

How To Use ADO.NET to Retrieve and Modify Records in an Excel Workbook

With Visual Basic .NET
<URL:http://support.microsoft.com/?scid=kb;EN-US;316934>

Samples:

How to handle events for Excel 2003 by using Visual Basic .NET
<URL:http://support.microsoft.com/?scid=kb;EN-US;822750>

HOW TO: Handle Events for Excel by Using Visual Basic .NET
<URL:http://support.microsoft.com/default.aspx?scid=kb;en-us;302814>

HOWTO: Automate Microsoft Excel from Visual Basic .NET
<URL:http://support.microsoft.com/?scid=kb;EN-US;301982>

HOW TO: Transfer Data to an Excel Workbook by Using Visual Basic .NET
<URL:http://support.microsoft.com/?scid=kb;EN-US;306022>

HOW TO: Handle Events for Excel by Using Visual C# .NET
<URL:http://support.microsoft.com/?scid=kb;EN-US;823981>

Related:

BUG: "Old Format or Invalid Type Library" Error When Automating Excel 2002 <URL:http://support.microsoft.com/?scid=kb;EN-US;320369>

PRB: Office Application Does Not Quit After Automation from Visual Studio .NET Client
<URL:http://support.microsoft.com/?scid=kb;EN-US;317109>

HOWTO: Use the WebBrowser Control to Open an Office Document in Visual Basic .NET
<URL:http://support.microsoft.com/?scid=kb;EN-US;304643>

INFO: Considerations for Server-Side Automation of Office
<URL:http://support.microsoft.com/?scid=kb;EN-US;257757>

More information:

<URL:http://support.microsoft.com/search/...&catalog=LCID%
3D1033>
There are loads of information about how to use Office applications together with .NET in the Microsoft Office Developer Center:

Microsoft Office Developer Center
<URL:http://msdn.microsoft.com/office/>

Office Development
<URL:http://msdn.microsoft.com/office/understanding/>

Can vb.net replace or enhance VBA that comes with the office suite?

You can write managed Office solutions using VB.NET.

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://dotnet.mvps.org/dotnet/faqs/>

[Luke Vogel]

Hi Andy,

Comments embedded ...

Can vb.net replace
Yes

or enhance VBA that comes with the office suite?

Umm.... possibly

The reason to use it is (IMO) because you have a dotnet app that needs

to do a bit of office functionality.
Maybe you have a production planning system has a bunch of screens and
crystal reports.
Some user manager then decides they want a dead complex 3d rotating excel chart.

Actually, I was more hoping that I could write code in the VS IDE and
import it into excel, or better still, use the VS IDE from within Excel
or Word.

I've been spoilt with intellisense and other IDE features, and I'm
finding it difficult to put the programs together without the
autocomplete features etc.

Cheers.

Luke.

[Herfried K. Wagner [MVP]]

Luke,

"Luke Vogel" <not@_real_address> schrieb:

Actually, I was more hoping that I could write code in the VS IDE and
import it into excel, or better still, use the VS IDE from within Excel
or Word.

That's what you can do with Visual Studio Tools for the Microsoft Office
System, for example. An introduction to Visual Studio Tools for Office can
be found here:

Using the Microsoft Visual Studio Tools for the Microsoft Office System
<URL:http://www.devx.com/codemag/Article/18233/>

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://dotnet.mvps.org/dotnet/faqs/>