136) 5/26/2006 198522 HOWTO: Place a Custom Bitmap on an Office Commandbar Button
(198522) - Using Automation, you can modify the Microsoft Office CommandBar to add one or more CommandBarButtons and customize the appearance of those additions with respect to the caption, the tooltip text, and the graphic image on the face. The graphic can be... 137) 11/29/2008 165517 OFF: Overview of Visual Basic Editor Debugging Tools
(165517) - The Microsoft Visual Basic Editor provides a rich set of debugging tools that you can use to troubleshoot problems with your Visual Basic for Applications macro code. This article describes some general debugging techniques that you can use to debug... 138) 12/1/2008 168836 HOWTO: Search for the Last Occurrence of a Substring
(168836) - The InStr() function provides a method to search for the first occurrence of one string (substring) inside another string. However, there is no intrinsic method to search for the last occurrence of a substring. This article provides a sample function... 139) 11/30/2008 168798 HOWTO: Parse City, State, and Zip Code into Separate Values
(168798) - This article provides a procedure for parsing a single variable containing US City, State, and Zip Code information into three separate variables. The routine supports: Either 5- or 9-digit zip code. Multi-word state names (if preceded by a comma).... 140) 11/27/2008 168799 HOWTO: Parse a Person's Name into Multiple Variables
(168799) - This article provides a procedure for parsing a single variable containing a person's name into up to 6 parts: Title (Mr., Ms., etc.) First Name Middle Initial(s) Last Name Pedigree (Jr., Sr., III, etc.) Degree(s) (B.S., PhD, etc.) 141) 10/29/2008 170721 OFF97: How to Create and Use a Global Array in VBA Procedures
(170721) - In Microsoft Visual Basic for Applications, you can create a dimensioned array, such as A(6,6), that is available to all procedures in all modules. This article includes sample Visual Basic for Applications routines that demonstrate how this can be... 142) 11/22/2008 180766 VBA: Sample Code to Determine CD-ROM Drive Letter
(180766) - This article contains sample Microsoft Visual Basic for Applications code that determines the drive letter of the first CD-ROM drive and returns it to a variable as a string. It is then output to a message box. This would be useful for accessing files... 143) 11/4/2008 170549 HOWTO: Read or Modify User-Defined DAO Properties
(170549) - This article provides two procedures that allow you to read and modify user- defined properties in a Microsoft Jet database. 144) 11/29/2008 182500 VBA: Error Message: "Class Not Registered" Inserting UserForm
(182500) - When you attempt to insert a UserForm while you are in the Microsoft Visual Basic Editor in one the products listed at the beginning of this article, or when you attempt to open a document that contains a UserForm, you may receive the following error... 145) 11/23/2008 176394 OFF97: ActiveX Control Copy or Drag Between Applications Fails
(176394) - When you insert an ActiveX control (for example, a command button) into a Microsoft Office 97 program, the following problems occur when you either copy and paste that ActiveX control or move it using a drag-and-drop operation. From PowerPoint 97 or... 146) 11/27/2008 169719 OFF97: Error in Macro Referencing Remote Data Objects
(169719) - If you run a macro that uses objects from the Microsoft Remote Data Object 2.0 library, you may receive the following error message: Run-time error '429' ActiveX component can't create object 147) 11/4/2008 169573 OFF: Some ShapeRange Methods Do Not Work for Mixed ShapeRanges
(169573) - When you run Microsoft Visual Basic for Applications code that executes certain ShapeRange methods on a selection of mixed shapes, such as a combination of pictures and OLE objects, you receive a run-time error. This problem occurs whether you create... 148) 11/24/2008 165639 OFF97: Macro That Retrieves the Number of Files in a Directory
(165639) - This article includes a sample Microsoft Visual Basic for Applications function that retrieves the total number of files that exist in a specified directory. The article also includes a procedure that demonstrates how to use the function. 149) 11/22/2008 165643 Visual Basic for Applications Macro That Displays a File List
(165643) - This article includes a sample Microsoft Visual Basic for Applications macro that retrieves the file names in a specified directory. The macro displays the file names in a message box. 150) 12/1/2008 161394 VBA: Sample Code to Retrieve the Current User Name
(161394) - The "More Information" section of this article contains sample Microsoft Visual Basic for Applications code that calls WNetGetUser (a Windows API function in the file Mpr.dll) to retrieve the user name used to establish a network connection.
1
.... 6
7
8
9
[ 10 ]
11
12
13
14
.... .... 58
59
Previous Page
Page 10 of 59
Next Page
|