Visual Basic Archives Page 57

-       Selva V Pasupathy , Hyderabad, India

   560. Benefits of On Line Consulting Read Microsoft Solution Study about development work performed by John F. Lacher CPA for D-Tools. The D-Tools development included components built with Visual Basic 6, Active Server Pages, Jet Databases, Visio, Excel, Access, Word and Project. Custom Application Development Via the Internet -… Keywords: Charts, Years, OLE, Formulas, PivotTables, Printing, Macro, VBA, Files, Text Files

   561. ACC: How to Use the Quit Macro Action or Quit Method This article demonstrates two methods that you can use to close Microsoft Access from a different application. The first method uses the Quit macro action to quit Microsoft Access over a dynamic da ta exchange (DDE) channel. The second method… KB#100149. Keywords: DDE, Microsoft Access, OLE, Errors, VBA, Macro, Object

   562. Sample Visual Basic Code to Create Color Index Table The sample macro in the More Information section of this article prints a sample of each color in one column, and then prints the index number for that color in the adjacent column. This type of li st is valuable for determining how a certain… KB#213801. Keywords: Colors, ColorIndex, Format, Patterns, Errors, Printing, VBA, Macro, Web

   563. Sample Macros to Return ID for a CommandBar Control The ID property for the CommandBar object uses a unique number for each built-in menu bar, shortcut menu bar, submenu, menu item, or toolbar. The ID is often required when you reference a control on a command bar. The Visual Basic for… KB#213211. Keywords: Charts, Formulas, PivotTables, VBA, Macro, Object, Menu Command, Toolbar, Web

   564. How to Use a Macro to Enter Cell Note Text in a Text Box This article describes how to put the text of a text note (cell note) into a text box. A macro that does this may be especially helpful if you are using Microsoft Excel for the Macintosh, becau se in this version of Microsoft Excel, you do not have… KB#142119. Keywords: Text Box, VBA, Macro, Web, Cell Note

   565. How to Export a Graph from Access to Excel You can use Microsoft Graph to embed a graph object in a Microsoft Access form or report. However, if you export the form or report to an Excel worksheet, the graph does not appear in the worksheet. This art icle describes how to export a… KB#208327. Keywords: Query, Export, Microsoft Access, Object

   566. How to Programmatically Delete and Restore a Menu That Contains a Submenu This article describes how to programamtically delete and restore a menu that contains a submenu. If you use a Microsoft Visual Basic for Applications macro to delete a menu it em that contains a submenu, and then you want to restore the menu item,… KB#213437. Keywords: VBA, Macro, Menu Command, Web

   567. How To Create a Dynamic Chart Using Visual Basic When you record a macro to create a chart, the source address of the cells you used to create the chart are fixed by Microsoft Excel. This article contains a Visual Basic for Applications macro that yo u can use to create a chart when the… KB#157940. Keywords: Charts, VBA, Macro, Object, Toolbar, Web

   568. How to Call a Macro Repeatedly on a Fixed Time Interval You can call a macro repeatedly at a set time interval using the OnTime method and the Call… KB#151503. Keywords: Format, VBA, Macro, Toolbar, Web

   569. How to Hide Button Controls with Visual Basic for Applications This article describes how to prevent buttons, such as command and option button controls, from being printed in the following situations. If the buttons are the only objects on the works heet. If the worksheet that you want to print contains… KB#213832. Keywords: Graphic, Format, Printing, VBA, Macro, Object, Web