Visual Basic Archives Page 33

-       Selva V Pasupathy , Hyderabad, India

   320. Excel Automation Fails Second Time Code Runs While running code that uses Automation to control Microsoft Excel, one of the following errors may occur: With Microsoft Excel 97 and later, you receive the error: Run-time error ‘1004′: Method ‘name of.. . KB#178510. Keywords: OLE, Errors, VBA, Object, Window

   321. Excel as Gridpaper for Drawing I always knew that Excel could be used to create some amazing drawings, but this week’s tip shows some new uses for Excel. These ideas are from Don Heckerman a former associate from my days at Telxon. Don is now the hea d of I.T. infrastructure in the Americas for a global logistics company. He… Keywords: Days, Borders, Fonts, Patterns, Sounds, VBA, Toolbar, Web, Column Width

   322. How to Set Page Setup Attributes for More Than One Sheet By default, page setup attributes, such as margins, sheet orientation, and print titles, are set individually (on a worksheet-by-worksheet basis). However, you can set some of these attributes globally by using any of the following methods: Use… KB#154663. Keywords: Format, Page Setup, Printing, VBA, Macro, Object, Templates, Toolbar, Web

   323. Macro to Obtain a List of Paper Names Supported by the Active Printer There is no built-in feature in Microsoft Visual Basic for Applications to obtain a list of paper names (Letter, Legal, A4, and so forth) supported by the active printer. This arti cle contains Visual Basic for Applications sample code that returns… KB#229718. Keywords: API, VBA, Macro, Web

   324. How to Temporarily Hide a UserForm In versions of Microsoft Excel earlier than Excel 97, if you use the Hide method to hide a custom dialog box, Excel does not hide the dialog box until the macro that contains the Hide method is finished running. In Excel 2000, if you use the… KB#213744. Keywords: Text Box, Command Button, VBA, Macro, UserForm, Web

   325. Procedure to Export Text File with Comma AND Quote Delimiter Microsoft Excel does not have a menu command to automatically export data to a text file so that the text file is exported with both quotation marks and commas as delimiters. For example, t here is no command to automatically create a text file… KB#123183. Keywords: Export, Errors, Printing, VBA, Iteration, Macro, File Name, Menu Command, Text Files, Web

   326. Sample Macro to Import Data with More Than 256 Fields or Columns Microsoft Excel spreadsheets have 256 columns (column IV). Therefore, Excel cannot accept data with more than 256 fields per record on a worksheet. When you attempt to manually import d ata from a database or text file that has more than 256 fields… KB#272729. Keywords: Import Data, Format, Errors, Macro, VBA, File Name, Text Files, Web

   327. How to Use a UserForm for Entering Data In Microsoft Excel, you can create a custom UserForm that provides a simple interface for entering data. This article includes steps for creating a custom UserForm and a sample Microsoft Visual Basic for Applic ations macro that places the data… KB#213749. Keywords: Text Box, Command Button, VBA, Macro, Object, UserForm, Web

   328. Macro to Obtain a List of Paper Names Supported by the Active Printer There is no built-in feature in Microsoft Visual Basic for Applications to obtain a list of paper names (Letter, Legal, A4, and so forth) supported by the active printer. This arti cle contains Visual Basic for Applications sample code that returns… KB#244639. Keywords: API, VBA, Macro, Web

   329. How to Programmatically Create a Reference This article provides sample Microsoft Visual Basic for Applications Sub procedures (or macros) that programmatically create and remove a reference to another project. NOTE: This functionality was not availa ble in Microsoft Excel for Windows… KB#160647. Keywords: Class, VBA, Macro, Object, VBE, Web, Window