Visual Basic Archives Page 8

-       Selva V Pasupathy , Hyderabad, India

   71. How to query and Display Excel Data by Using ASP.NET, ADO.NET, and Visual Basic .NET This step-by-step article demonstrates how to display data from an Excel spreadsheet through an ASP.NET (.aspx) page by using Visual Basic .NET. Create Sample Excel W orksheet Start Microsoft Excel, and create a new worksheet. Add the… KB#311731. Keywords: Text Box, Query, OLE, SQL, XML, Class, Object, VBA, File Name, Files, Web, Comments, Window, DB

   72. How to convert Text to Numbers in Excel 2003 This step-by-step article describes how to convert cells that contain text to cells that contain numbers. When you import a file that was created in another program (such as dBASE or Lotus 1-2-3) or that wa s downloaded from a mainframe, Excel 2003… KB#822665. Keywords: Third-Party, Format, Errors, Formulas, Macro, VBA, Web, AVERAGE, LEFT, TRIM, CLEAN, VALUE

   73. How to import Data into SQL Server from Excel This step-by-step article demonstrates how to import data from Microsoft Excel worksheets into Microsoft SQL Server databases by using a variety of methods. Description of the Technique The samples in this article import Excel data by using:… KB#321686. Keywords: Query, ActiveX, DAO, Import Data, Microsoft Access, OLE, SQL, Format, Object, VBA, Links, DB

   74. How to use the Forms Controls on a Worksheet in Excel 2000 This step-by-step article describes how to use the forms controls in a worksheet in Microsoft Excel 2000. Microsoft Excel provides several controls for dialog sheets. These controls can be use d on worksheets to help you select data. For… KB#214262. Keywords: Format, Formulas, Combo Box, Object, VBA, Toolbar, Links, INDEX

   75. Recording and customizing a macro This is the 19th weekly tip at www.MrExcel.com. Many of the tips involve some sort of macro trick. This week, for the Excel users who have never written a macro, I offer a primer on how to record and then customize a useful Excel macro. This simple problem will be used to illustrate how to record,… Keywords: Sorting, Format, Errors, VBA, Macro, Object, Toolbar, Web

   76. Event Macro to Add Path and Filename to Excel Header Now, on to writing the VBA code. There are a couple of useful variables that you can use. ActiveWorkbook.Path will return the path of the workbook. It might look like “C:\My Documents\MrExcel”. Acti veWorkbook.FullName will return the path and filename of the workbook. It might look like “C:\My… Keywords: Add-In, Years, Errors, Printing, VBA, Macro, Object, Setup, File Name, Toolbar, Web

   77. How to use the Forms Controls on a Worksheet in Excel 2002 Microsoft Excel provides several controls for dialog sheets. You can use these controls on worksheets to help select data. For example, drop-down boxes, list boxes, spinners, and scroll bars a re useful for selecting items from a list. By adding… KB#291073. Keywords: Format, Formulas, Combo Box, Object, VBA, Toolbar, Links, INDEX

   78. How to handle events for Excel 2003 by using Visual Basic .NET This step-by-step article describes how to handle Microsoft Office Excel 2003 events from an Automation client that you develop by using Visual Basic… KB#822750. Keywords: Arrays, Errors , Class, VBA, Object, Error Message, Web, Window

   79. How to Programmatically Perform a Web Query A Web query is a new feature in Microsoft Excel 97 that allows you to retrieve data stored on an intranet, the Internet, or the World Wide Web. A Web query can use static parameters, dynamic parameters, or a combination of both. Queries with… KB#162080. Keywords: Query, Symbol, VBA, Macro, Object, Files, Toolbar, Web

   80. How to Return Data from a Dialog Box to a Worksheet In Microsoft Excel, each type of control on a custom dialog box (a drop- down list, an edit box, and others) has a distinct return value that can be returned to a worksheet. This article describes ho w to create a custom dialog box and contains… KB#141685. Keywords: Fonts, Arrays, Formulas, VBA, Macro, Object, Toolbar, Web