|
|
|
|
|
Total Hits: 6 | Today: 0
|
Author: Matthew A. Stoecker
|
Rating:
|
|
Arrays provide convenient ways to work with groups of controls that share common functionality. Groups of controls might be used to display related data, or provide related behavior when clicked, for example. Although Visual Basic® .NET and Visual C#® have no inherent support for creating control arrays, you can duplicate all of the functionality of control arrays programmatically. This article will walk you through the creation of a simple component that duplicates control array functionality....
|
|
|
|
Total Hits: 8 | Today: 0
|
Author: Alok Mehta
|
Rating:
|
|
Microsoft® Office 2003 contains powerful XML-based functionality, including Web services integration. For example, using the Web services capabilities of Office 2003, developers can create a variety of solutions that help users increase their productivity on eBay. Web services offered by eBay allow you to use Excel to manage dynamic listing data, such as pricing and bids, and update this data automatically as changes occur. Solutions could also enable users to list multiple items on eBay simulta...
|
|
|
|
Total Hits: 15 | Today: 0
|
Author: RichElswick
|
Rating:
|
|
You may have created one too many sheets in Excel, and now you want to move the sheets to separate files. Yes, you can do it by right clicking a sheet and Move/Copy it to a 'new book', but, what if you have more than 255 characters in a cell? It gets truncated. Yes, you can copy/paste and compare cells until you get all of them moved over, but that is tedious....
|
|
|
|
Total Hits: 17 | Today: 0
|
Author: Johan Fourie
|
Rating:
|
|
This small article is about of a SharePoint caveat that I encountered while developing a WebPart. The cause of the problem was the command Directory.CreateDirectory(Server.MapPath("testdir")). This indirectly breaks SharePoint and results in an HTTP 404 error....
|
|
|
|
Total Hits: 25 | Today: 0
|
Author: Ed Robinson
|
Rating:
|
|
Creating status reports is a common requirement in many line-of-business applications that are written with Microsoft Visual Basic. However, the way in which your users end up consuming that data—probably, in a Microsoft Office application—isn't the way in which you're likely to pull it from an application. In the first two articles of this series, I showed how to use Office Word and Office Excel as a reporting tool by pulling data directly from a data source into a Microsoft Office document....
|
|
|
|
Total Hits: 46 | Today: 0
|
Author: Mahesh Chand
|
Rating:
|
|
This program shows how access an access database using ADO. I have an Access 2000 database in project\bin\debug directory. My database name is mcTest.MDB. You can create your own database and copy in your project's debug directory. I am not attaching database with this code because of size problem....
|
|
|
|
Total Hits: 64 | Today: 0
|
Author: dynamicajax
|
Rating:
|
|
It seems quite often that I need to programmatically create an Excel spreadsheet with data from a database or some other location. I usually just create a CSV (comma separated value) file and dump the results. There are many times when it would be much nicer to create a real Excel file where I could add formatting and additional worksheets. I have a list of files that I need dumped to a spreadsheet on a regular basis with each different directory being located in a new worksheet. I went looking ...
|
|
|
|
Total Hits: 28 | Today: 0
|
Author: Microsoft Corporation
|
Rating:
|
|
This article describes how to use automation to create and to show a Microsoft PowerPoint presentation by using Microsoft Visual Basic .NET 2002 or Visual Basic .NET 2003. Start Microsoft Visual Studio .NET 2002 or Visual Studio .NET 2003. On the File menu, click New and then click Project. Select Windows Application from the Visual Basic Projects types. Form1 is created by default....
|
|
|
|
Total Hits: 75 | Today: 0
|
Author: ketan_lohar
|
Rating:
|
|
When we develope office applications we need to automate Excel Activity.This can be achieved by VBScript. VBScript support "Excel.Application". Through which we can do comman excel taskautomatically....
|
|
|
|
Total Hits: 81 | Today: 0
|
Author: Dennis Betten
|
Rating:
|
|
First of all, I need to give some credit to Marc Brooks for publishing code which made it possible for me to make my code about a hundred times faster as it originaly was!
What does this code do:
As the title says, this code is capable of extracting all tables and it's data from any given database and export it to Excel! Every table gets it's own worksheet. I was searching the net for a program like this, but I didn't come accross any (free) versions. So I decided to write it myself....
|
|
|
|
Total Hits: 35 | Today: 0
|
Author: Alessandro Del Sole
|
Rating:
|
|
With the release of .NET Framework 3.0, Microsoft introduced a new file format called XPS (Xml Paper Specifications) with .Xps extension. This file format was thought as a standard for documents portability; in fact, XPS documents can be read on every system without having installed the originating application (as it is for .PDF documents).
.NET Framework 3.x fully supports this kind of documents which can be created and manipulated with extreme precision. Manipulating this kind of docume...
|
|
|
|
Total Hits: 23 | Today: 0
|
Author: Ed Robinson, Intergen Ltd
|
Rating:
|
|
In Word, automation is a great mechanism for populating business documents (like invoices and reports) with data from backend systems. Learn three useful methods for populating Word documents with data....
|
|
|
|
|
|
