.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!

 

[Andy O'Neill]

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.

 

[Herfried K. Wagner [MVP]]

Luke,

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=1033>

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

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

You can write managed Office solutions using VB.NET.

 

[chanmmn]

Play with the sample code here:

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

chanmm

 

[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.

 

[Luke Vogel]

Hi Andy,

Comments embedded ...

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,

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/>