Visual Basic Archives Page 37

-       Selva V Pasupathy , Hyderabad, India

   360. Defined Names Are Case Sensitive When you run a Visual Basic for Applications macro in Microsoft Excel, and your macro code reads the Name property of an item in the Names collection, the result may be slightly different than the result you receive i n versions of Excel earlier… KB#213533. Keywords: Arrays, Defined Name, VBA, Macro, Web

   361. 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… KB#213529. Keywords: Class, VBA, Macro, Objec t, VBE, Web, Window

   362. Lots ‘o Little Code I have been adding a lot of whole programs so I thought this was a good time to drop back to basics and show how I do some little stuff. This is a start, more to come shortly. So you have a password on some cells. You need to sort or something in your code but your users should not be able to move… Keywords: Sorting, Colors, Arrays, Errors, Formulas, Password, VBA, Macro, File Name, Scenarios, AVERAGE, INDIRECT

   363. How to Reduce the Chances of Macro Virus Infection This article explains how you can reduce the risk of infecting Microsoft Excel — including your worksheets, templates, and add-ins — with macro… KB#269613. Keywords: Third-Party, Password, Macro, VBA

   364. Cannot Open Workbook That Contains XLM Macros When Macro Security Is Set to High When you try to open a workbook, you receive the following error message: This workbook cannot be opened under High Security Level because it contains a type of macro (M icrosoft Excel 4.0 macro) that cannot be disabled or signed. To open… KB#820739. Keywords: Errors, Macro, VBA, Registry

   365. Cannot Insert File Using Named Range of Excel File When you attempt to insert a named range from a Microsoft Excel file, you receive the following error message: The document name or path is not valid. Try these suggestions. * Check the file permissi ons for the document or drive. * Use the File… KB#224699. Keywords: Errors, VBA, Macro, Files, Toolbar, Web

   366. Visual Basic Example Using If and Case Statements Then…Else statement or a Select Case statement. The If…Then…Else statement executes a group of statements based on… KB#141691. Keywords: VBA, Macro, Web

   367. How to Use the Registry to Override the Default Behavior When Excel Tries to Recover Data Excel 2003 contains a feature that allows you to recover data from corrupted workbooks. This article describes how to use the registry to override the default b ehavior when Excel tries to recover… KB#826836. Keywords: Formulas, Object, VBA, Corrupted, Registry

   368. How to Convert All Files on a Server to Microsoft Excel The Microsoft Excel 97 File Conversion add-in converts all of the files in one folder. This article describes how to use a Visual Basic for Applications macro to convert the files in a folder an d all of its… KB#170431. Keywords: Add-In, Format, VBA, Macro, Object, Files, Toolbar, Web

   369. Visual Basic Macro to List Circular References In a Microsoft Excel 2000 worksheet, when a formula in a cell refers to the same cell the formula occupies, either directly or indirectly, a circular reference is created. In Excel 2000, tracing tools ar e provided on the Auditing toolbar to help… KB#213826. Keywords: Errors, Formulas, VBA, Macro, Circular References, Toolbar, Web, Auditing