Connecting Tech Pros Worldwide Forums | Help | Site Map

.NET and Office applications programming

Luke Vogel
Guest
 
Posts: n/a
#1: Nov 21 '05
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
Guest
 
Posts: n/a
#2: Nov 21 '05

re: .NET and Office applications programming




"Luke Vogel" <not@_real_address> wrote in message
news:OSu3P6a6EHA.2032@tk2msftngp13.phx.gbl...[color=blue]
> Hi all ... could someone point me in the right direction for programming
> office applications (specifically excel) using vb.net?
>
> Can vb.net replace[/color]

Yes
[color=blue]
> or enhance VBA that comes with the office suite?[/color]

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.
[color=blue]
>
> cheers... have a great Christmas all!
> --[/color]

Merry christmas.


--
Regards,
Andy O'Neill


Herfried K. Wagner [MVP]
Guest
 
Posts: n/a
#3: Nov 21 '05

re: .NET and Office applications programming


Luke,

"Luke Vogel" <not@_real_address> schrieb:[color=blue]
> could someone point me in the right direction for programming
> office applications (specifically excel) using vb.net?[/color]

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/>
[color=blue]
> Can vb.net replace or enhance VBA that comes with the office suite?[/color]

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
Guest
 
Posts: n/a
#4: Nov 21 '05

re: .NET and Office applications programming


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:OSu3P6a6EHA.2032@tk2msftngp13.phx.gbl...[color=blue]
> 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
> -----
>
>[/color]


Luke Vogel
Guest
 
Posts: n/a
#5: Nov 21 '05

re: .NET and Office applications programming


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]" <hirf-spam-me-here@gmx.at> wrote in message
news:uyqhZgb6EHA.128@TK2MSFTNGP15.phx.gbl...[color=blue]
> Luke,
>
> "Luke Vogel" <not@_real_address> schrieb:[color=green]
> > could someone point me in the right direction for programming
> > office applications (specifically excel) using vb.net?[/color]
>
> 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[/color]
With[color=blue]
> 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[/color]
2002[color=blue]
> <URL:http://support.microsoft.com/?scid=kb;EN-US;320369>
>
> PRB: Office Application Does Not Quit After Automation from Visual[/color]
Studio[color=blue]
> .NET Client
> <URL:http://support.microsoft.com/?scid=kb;EN-US;317109>
>
> HOWTO: Use the WebBrowser Control to Open an Office Document in Visual[/color]
Basic[color=blue]
> .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:
>
>[/color]
<URL:http://support.microsoft.com/search/...&catalog=LCID%
3D1033>[color=blue]
>
> There are loads of information about how to use Office applications[/color]
together[color=blue]
> 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/>
>[color=green]
> > Can vb.net replace or enhance VBA that comes with the office suite?[/color]
>
> 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/>
>
>[/color]


Luke Vogel
Guest
 
Posts: n/a
#6: Nov 21 '05

re: .NET and Office applications programming


Hi Andy,

Comments embedded ...
[color=blue][color=green]
> >
> > Can vb.net replace[/color]
>
> Yes
>[color=green]
> > or enhance VBA that comes with the office suite?[/color]
>
> Umm.... possibly
>
> The reason to use it is (IMO) because you have a dotnet app that needs[/color]
to do[color=blue]
> 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[/color]
excel[color=blue]
> chart.[/color]

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]
Guest
 
Posts: n/a
#7: Nov 21 '05

re: .NET and Office applications programming


Luke,

"Luke Vogel" <not@_real_address> schrieb:[color=blue]
> 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.[/color]

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


Closed Thread