Search - Articles
DevASP.NET for ASP.NET, VB.NET, XML and C# (C-Sharp) Developers Tuesday, March 03, 2009
Dev Articles
Search Directory
ASP.NET
VB.Net
C-Sharp
SQL Server
 


Home >Search > Articles & Samples > Visual Basic.Net > Office Documents
Search:
What's New - What's Hot
Listings for Excel Excel (45)
Listings for General General (19)
Listings for Power Point Power Point (4)
 


Implement a Microsoft Word-like Object Model for Your .NET Framework Application     
Total Hits: 161  |  Today: 0Author: Omar AL Zabir      Rating:  
Read Reviews | Write Review |  Your Rating: 

All Microsoft Office applications are built on top of an object model that supports automation. Any developer can use the 0bject model to drive the application UI and add, edit, and delete content, just as a real user interacts with the application. The rich object model, together with automation support, makes Office applications truly extensible and pluggable. Anyone can write a powerful add-in within a very short time in order to extend the behavior of Microsoft Word according to their own ne...

C# and VBA: Like Oil and Water     
Total Hits: 205  |  Today: 0Author: Ken Getz      Rating:  
Read Reviews | Write Review |  Your Rating: 

Some things just don't mix as well as you would like. Take C# and Microsoft® Excel 2003 or Word 2003, for example. Not only are these applications huge productivity tools, but they both also provide access to large object models that you can program against from your own applications. The problem is none of the documentation for the object models includes code samples for developers writing managed code, and writing Visual Basic® for Applications (VBA) code is quite unlike writing C# code....

Secure and Deploy Business Solutions with Microsoft Visual Studio Tools for Office     
Total Hits: 229  |  Today: 0Author: Brian A. Randell and Ken Getz      Rating:  
Read Reviews | Write Review |  Your Rating: 

Microsoft Visual Studio Tools for the Microsoft Office System is a new technology that brings the advanced features of Visual Studio .NET and the .NET Framework to applications built for Microsoft Office Word 2003 and Microsoft Office Excel 2003. Deploying solutions built with this technology requires that you understand how runtime security is enforced in managed applications and how to configure users' systems to run your solutions without introducing security holes....

Pulling Stock Quotes into Microsoft Excel     
Total Hits: 288  |  Today: 0Author: Steven Roman, Ph.D.      Rating:  
Read Reviews | Write Review |  Your Rating: 

Microsoft has spent a lot of time and effort trying to convince us to place Office documents on our Web sites -- witness the Microsoft Office 2000 Web Components, which are ActiveX controls designed to bring spreadsheet (Excel) and database (Access) functionality to a Web site. Whole books have been written about these Web components....

Creating Threads in VB.NET to Manipulate Microsoft Excel     
Total Hits: 1432  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

Ok first thing first: You will need to add a COM reference to Microsoft Office 10 Object Library. (Version 9 will also work...) This is needed to use the Excel Objects, unfortunately there is no .NET version that I know of, so we have to use the COM version....

HOWTO: Handle PowerPoint Events With Visual Basic .NET     
Total Hits: 1405  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article demonstrates how to automate PowerPoint and handle events using Visual Basic .NET.
...

HOW TO: Query and Display Excel Data by Using ASP.NET, ADO.NET, and Visual C# .NET     
Total Hits: 10527  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This step-by-step article demonstrates how to display data from an Excel worksheet through an ASP.NET (.aspx) page by using Visual C# .NET....

HOW TO: Create an Excel Macro by Using Automation from Visual Basic .NET (Q303871)     
Total Hits: 1535  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article demonstrates how you can automate Excel from Visual Basic .NET to create a workbook that contains a new macro associated with a CommandBar button....

HOW TO: Transfer Data to an Excel Workbook by Using Visual Basic .NET (Q306022)     
Total Hits: 5027  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This step-by-step article describes numerous methods for transferring data to Excel 2000 or Excel 2002 from a Visual Basic .NET application. This article also presents the advantages and disadvantages of each method so that you can choose the solution that works best for your situation....

HOW TO: Build an Office COM Add-in by Using Visual Basic .NET (Q302896)     
Total Hits: 839  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

Microsoft Office 2000 and later support a new, uniform design architecture for building application add-ins to enhance and control Office applications. These add-ins are called COM add-ins. This step-by-step article discusses Office COM add-ins and describes how to build an Office COM add-in by using Visual Basic .NET....

HOW TO: Handle Events for Excel by Using Visual Basic .NET (Q302814)     
Total Hits: 1577  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This step-by-step article describes how to handle Excel events from an Automation client that is developed with Visual Basic .NET....

HOWTO: Automate Excel From Visual Basic .Net To Fill or Obtain Data In a Range Using Arrays (Q302094)     
Total Hits: 2605  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article demonstrates how to automate Excel and fill a multi-cell range with an array of values. This article also illustrates how to retrieve a multi-cell range as an array by using Automation....

Pulling Stock Quotes into Microsoft Excel     
Total Hits: 1238  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

Steve Roman, the author of O'Reilly's Writing Excel Macros, shows how to keep a spreadsheet up to date by pulling stock quotes from the Web.
...

HOW TO: Use ADO.NET to Retrieve and Modify Records in an Excel Workbook With Visual Basic .NET (Q316934)      
Total Hits: 4588  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article discusses how you can use ADO.NET to retrieve data from a Microsoft Excel workbook, modify data in an existing workbook, or add data to a new workbook. To access Excel workbooks with ADO.NET, you can use the Jet OLE DB provider; this article provides the information that you need so that you can use the Jet OLE DB provider when Excel is the target data source.
...

HOW TO: Query and Display Excel Data by Using ASP.NET, ADO.NET and Visual Basic .NET (Q311731)     
Total Hits: 3190  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This step-by-step article demonstrates how to display data from an Excel spreadsheet through an ASP.NET (.aspx) page by using Visual Basic .NET....

HOWTO: Automate Microsoft Excel from Visual Basic .NET (Q301982)     
Total Hits: 3015  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article demonstrates how to create an Automation client for Excel using Visual Basic .NET. Automation is a process that allows applications that are written in languages such as Visual Basic .NET to programmatically control other applications. Automation to Excel allows you to perform actions such as creating a new workbook, adding data to the workbook, or creating charts. With Excel and other Microsoft Office applications, virtually all of the actions that you can perform manually through ...

Q304661 - BETA-HOWTO: Binding for Office Automation Servers with Visual Basic .NET     
Total Hits: 762  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

When you automate an application such as a Microsoft Office application, the calls to the properties and methods of the Office application's objects must be connected in some way to those objects. The process of connecting property and method calls to the objects that implement those properties and methods is commonly called binding. In Visual Basic .NET, the two types of binding that are available are early binding and late binding. The type of binding you choose can affect many aspects of your...

Q303871 - BETA-HOWTO: Create an Excel Macro Using Automation from Visual Basic .NET     
Total Hits: 2123  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article demonstrates how you can automate Excel from Visual Basic .NET to create a workbook that contains a new macro associated with a CommandBar button....

HOWTO: Use VB .NET to Create and Show a PowerPoint Presentation - Q303717     
Total Hits: 1401  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article demonstrates how you can automate PowerPoint from Visual Basic .NET to create and show a PowerPoint presentation....

Q302814 - BETA-HOWTO: Handle Events for Microsoft Excel Using Visual Basic .NET     
Total Hits: 937  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article illustrates how to handle Excel events from an Automation client that is developed with Visual Basic .NET....



Disclaimer - Privacy
© 2002-2017 DevASP.net