By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,818 Members | 1,094 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,818 IT Pros & Developers. It's quick & easy.

Excel Automation with .NET

P: n/a
Does anyone have some good examples of Excel automation with (VB).NET?

I have some Excel spreadsheets that a customer needs parsed out but I've
never tried to use Excel programatically before!

Thanks!

--
- Mitchell Vincent
- kBilling - Invoices Made Easy!
- http://www.k-billing.com
Nov 21 '05 #1
Share this Question
Share on Google+
3 Replies

P: n/a

That is a topic that is not going to be taught with a few examples.
Automation can be a tricky thing.

My best bet for you is to outsource. I am available :).

Kelly

"Mitchell Vincent" <mv******@newsgroup.nospam> wrote in message
news:eS*************@TK2MSFTNGP15.phx.gbl:
Does anyone have some good examples of Excel automation with (VB).NET?

I have some Excel spreadsheets that a customer needs parsed out but I've
never tried to use Excel programatically before!

Thanks!

--
- Mitchell Vincent
- kBilling - Invoices Made Easy!
- http://www.k-billing.com


Nov 21 '05 #2

P: n/a
"Mitchell Vincent" <mv******@newsgroup.nospam> schrieb:
Does anyone have some good examples of Excel automation with (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/>

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://classicvb.org/petition/>

Nov 21 '05 #3

P: n/a
Herfried K. Wagner [MVP] wrote:
"Mitchell Vincent" <mv******@newsgroup.nospam> schrieb:
Does anyone have some good examples of Excel automation with (VB).NET?


Excellent stuff Herfried! Thanks!

--
- Mitchell Vincent
- kBilling - Invoices Made Easy!
- http://www.k-billing.com
Nov 21 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.