|
|
 |
Working with the PivotTable Component's Object Model
|
| Total Hit (2250) |
The PivotTable List control is represented in the object model by the PivotTable object. You use the DataSource property to specify the source of the data to be displayed in the control. Typically, this property setting will consist of an ADO data source or another one of the Office Web Component co
....Read More |
Rating
 |
|
|
|
|
|
|
|
HOWTO: Navigate Excel Objects from Visual Basic
|
| Total Hit (2177) |
This article explains three methods you can use to navigate and access Microsoft Excel Application objects:
«LI»Using longhand and default properties
«LI»Using aliasing
«LI»Using the Parent and Application methods of Microsoft Excel version 5.0 objects to access any Microsoft Excel object
....Read More |
| Rating
|
|
|
|
Fill in Word Forms Using Information Stored in Access
|
| Total Hit (967) |
Although Access reports are flexible and relatively easy to create, they're not always suitable for every task. For example, your company may internally use manual forms that can easily be filled with data from an existing Access database. Your natural reaction is probably to create an Access report
....Read More |
| Rating
|
|
|
|
XPath Visualizer:A visual tool to test your XPath Statements
|
| Total Hit (1463) |
XPath Visualiser is a tool that enables you to test your XPath queries.
This is a full blown Visual XPath Interpreter for the evaluation of any XPath expression and visual presentation of the resulting nodeset or scalar value.
«b»Screenshots:«/b»
«a href="http://www.vbxml.com/xpathvisualizer
....Read More |
| Rating
|
|
|
|
Tutorial - TreeView Control Introduction
|
| Total Hit (1763) |
The Tree View control is a Visual Basic version of the control you see used in many programs, including Explorer and FrontPage, used to list the folders on your hard disk. This control allows you to add nodes to a tree, each of which can have sub items. Below is an image of the Tree View control in
....Read More |
| Rating
|
|
|
|
|
|
|
|
Changing File and/or Folder Attributes Recursively
|
| Total Hit (1329) |
The basic recursion techniques from Performing Recursive Searches Using FindFirst and SearchTreeForFile are used in this demo, but modified to include code for changing either the file, folders or both beneath the target directory specified. The code returns to the list all files processed, as well
....Read More |
| Rating
|
|
|
|
Locking Removable Media Devices Using DeviceIoControl
|
| Total Hit (1515) |
Using DeviceIoControl, together with the PREVENT_MEDIA_REMOVAL data user-defined type and the IOCTL_STORAGE_MEDIA_REMOVAL control code, it is possible for WinNT/Win2000 users to lock and unlock any removable device. A removable device might include, as it does on my system, CD-ROMs and LS-120 drive
....Read More |
| Rating
|
|
|
|
Checking for Media Availability Using DeviceIoControl
|
| Total Hit (1363) |
This is the DeviceIoControl method for determining if a given drive has media present. The nice thing about this call is that it does not need to spin up the disk - the call returns instantly. The only lag might be if a new disk was inserted and the call was made while the OS was spinning up the dri
....Read More |
| Rating
|
|
|
|
|
|
Obtaining Processor Information using WMI
|
| Total Hit (1324) |
Windows Script Host is built into Microsoft Windows 98, 2000, ME and XP. If you are running Windows 95 or NT4, you can download Windows Script Host from the Microsoft Windows Script Technologies Web site at http://msdn.microsoft.com/scripting/. Some information is not returned on non-NT-based system
....Read More |
| Rating
|
|
|
|
Enumerating Share Connection Information
|
| Total Hit (1456) |
The WNetEnumResource API continues enumeration of network resources on the local computer that was started by a call to the WNetOpenEnum API function. It will not retrieve the shares in use on remote machines. The illustration shows the function enumerating all network resources on my development ne
....Read More |
| Rating
|
|
|
|
How to Share a Folder using NetShareAdd
|
| Total Hit (1445) |
The NetShareAdd function shares a server or workstation resource. Only members of the Administrators or Account Operators local group, or those with Communication, Print, or Server operator group membership can successfully execute the NetShareAdd function. The Print operator can add only Printer qu
....Read More |
| Rating
|
|
|
|
Connecting to Network Resources
|
| Total Hit (1624) |
These are small network routines that provide developers with increased functionality and usability.
The first two routines deal with displaying the Map Drive and Disconnect Mapped Drive dialogs.
The second two deal with printers; the first shows the Windows dialog responsible for setting up a
....Read More |
| Rating
|
|
|
|
Enumerating Shared Resources on Remote Machines
|
| Total Hit (1558) |
NetShareEnum retrieves information about each shared resource on a server. It's security requirements are the same as those outlined in Obtaining Workstation User Logon Information.
WNetEnumResource can also be used to retrieve resource information, however, it does not enumerate hidden shares or
....Read More |
| Rating
|
|
|
|
Translating a Mapped Drive to a UNC Path
|
| Total Hit (1510) |
WNetGetConnection, when passed the drive letter of a mapped drive, will return the full UNC path to the \\server\share that drive is mapped to. By adding a few Shell APIs we can create wrapper routines to perform tests on the constituent portions of the mapped path to assure the returned value point
....Read More |
| Rating
|
|
|
|
Search for values in a FlexGrid control and sort it by columns
|
| Total Hit (2276) |
To search for values, simply loop through the grid looking for the target value. Use the TopRow property to ensure that the row is visible after you find it.
To sort by columns, use the MouseRow property to see if the user clicked the control's column header. Use MouseCol to see which column was
....Read More |
| Rating
|
|
|
|
HOWTO: Use the Chart Web Component with Visual Basic
|
| Total Hit (2450) |
This article shows the different ways that you can access the documentation for Microsoft Office Web Components (OWC). The article also includes information about additional resources for programming the OWC.
|
| Rating
|
|
|
|
HOWTO: Use the Spreadsheet Web Component with Visual Basic
|
| Total Hit (2233) |
You can add the Office Web Components to a form in Visual Basic in the same way that you add any other ActiveX control. The Spreadsheet control included with the Office Web Components is a more robust option than the DataGrid control that ships with Visual Basic. Use the spreadsheet data to display
....Read More |
| Rating
|
|
|
|
|
|
|
|
XL97: How to Create a GIF File from a Microsoft Excel Chart
|
| Total Hit (3221) |
To programmatically create a graphics file from a Microsoft Excel chart, use the Export method. This article contains a sample Microsoft Visual Basic for Applications macro that creates a .gif file from a chart in a Microsoft Excel workbook.
NOTE: If you click Save As HTML on the File menu and u
....Read More |
| Rating
|
|
|
|
|
|
|
|
Five Tips for the Microsoft Office XP Web Components
|
| Total Hit (1628) |
Discover how you can retain the original format of the numbers in a PivotTable component, determine which version of the Office Web Components you have, and more. This article provides the sample code that you can use in you own applications which use the Office XP Web components.
«b»Contents«/b»
....Read More |
| Rating
|
|
|
|