Microsoft Excel version 5 now contains Visual Basic for Applications, Microsoft's new common macro language. Visual Basic for Applications offers a more flexible way to read and write macros, to make Microsoft Excel automatically work more like you do, and to build multiple application solutions with Microsoft Excel. The Microsoft Excel 5 Visual Basic for Applications Reference is a complete description of the macro language; it parallels the online reference in Microsoft Excel 5. This book is an A-to-Z reference to the elements that make up the new common macro language - in it you'll find descriptions, explanations of proper syntax, and code examples for all the objects, properties methods, functions, and statements in Visual Basic for Applications. You'll also learn about Visual Basic for Applications features, such as Menu Builder, Object Browser, Code Debugger, Breakpoints, Watch Variables, Dialog Sheets, and On-Sheet Controls. Whether you're writing macros for your own use or creating custom applications using Microsoft Excel as a development platform, you'll find the Microsoft Excel 5 Visual Basic for Applications Reference to be essential.Before you use the function, you must establish a reference to the XLODBC add- in using the References command from the Tools menu. For more information, see aquot;Calling Procedures in Another Workbook, aquot; in the Visual Basic for Applications Usera#39;s Guide. Syntax ... SQLError Function Description Returns detailed error information when called after one of the other ODBC functions fails. If SQLError itselfanbsp;...
|Title||:||Microsoft Excel Visual BASIC for Applications Reference|