Visual Basic Archives Page 63

-       Selva V Pasupathy , Hyderabad, India

   620. How to Programmatically Save a File to a Network Drive In Microsoft Excel, you can save a file to any drive to which you have write and delete privileges. In addition, you can use a Microsoft Visual Basic for Applications macro to save the active wor kbook and use a variable for the file name. You can… KB#213641. Keywords: VBA, Macro, File Name, Save A File, Web

   621. How to Hide and Restore a BuiltIn Menu When you use the Delete method in a Visual Basic for Applications macro to delete a menu from a built-in menu bar, you cannot restore the menu and all of its associated menu items with one macro command. If you want to remove a menu and then… KB#213708. Keywords: VBA, Macro, Object, Web

   622. Rounding numbers If I enter a formula to take one-third of a number like 100,000 – how can I round that result to get just the whole number portion, or even just the thousands? I know I can format it to hide the decimals, but I don’t want the decimal s to enter into subsequent calculations?Surround the formula with… Keywords: Add-In, Consolidate, Download, Format, Formulas, Links, VBA, Web, ROUND

   623. Getting Rid of Broken Links If I enter a formula to take one-third of a number like 100,000 – how can I round that result to get just the whole number portion, or even just the thousands? I know I can format it to hide the decimals, but I don’t want the decimals to enter into subsequent calculations?Surround the formula with… Keywords: Add-In, Consolidate, Download, Format, Formulas, Links, VBA, Web, ROUND

   624. Getting Rid of Broken Links If I enter a formula to take one-third of a number like 100,000 – how can I round that result to get just the whole number portion, or even just the thousands? I know I can format it to hide the decimals, but I don’t want the decimals to enter into subsequent calculations?Surround the formula with… Keywords: Add-In, Consolidate, Download, Format, Formulas, Links, VBA, Web, ROUND

   625. How to Control the Placement of Objects In Microsoft Excel 97, you can control how charts, drawing objects, AutoShapes, controls, and other objects contained in a worksheet are attached to the cells below them. This article explains how to set the Pl acement property for objects in… KB#168651. Keywords: Charts, AutoShapes, Format, Styles, Errors, Class, Macro, Object, VBA, Window

   626. How to Populate One ListBox Based On Another ListBox This article contains an example of using the selected item in one ListBox control on a UserForm to determine the list that will populate a second ListBox… KB#161518. Keywords: VBA, UserForm, Web , Window

   627. How to Display a ComboBox List When a UserForm Is Displayed When a UserForm is displayed, you can display the list for a ComboBox control by using the Activate event for the UserForm. This article includes an example that uses the DropDown method of a ComboBox and the Activate method of a UserForm… KB#213718. Keywords: VBA, UserForm, Web, Window

   628. How to Automate Inserting an Excel Chart into Word This article includes a sample Microsoft Visual Basic for Applications macro that inserts an existing Microsoft Excel chart into a new Word… KB#212514. Keywords: Charts, VBA, Macro, Object, File Na me, Web

   629. How to Use DAO to Create a New Microsoft Excel Workbook In Microsoft Excel 2000, you can use the Data Access Object (DAO) library in a Microsoft Visual Basic for Applications macro to work with an external database. You can create a new Excel workboo k with DAO using the instructions included in… KB#213811. Keywords: DAO, Defined Name, VBA, Macro, Object, Web