04714nam 2200637Ia 450 991078328270332120230617030339.01-280-54428-797866105442881-930919-52-2(CKB)1000000000023680(EBL)3301811(SSID)ssj0000282501(PQKBManifestationID)11225072(PQKBTitleCode)TC0000282501(PQKBWorkID)10317222(PQKB)10089608(MiAaPQ)EBC3301811(Au-PeEL)EBL3301811(CaPaEBR)ebr10120756(CaONFJC)MIL54428(OCoLC)560106499(EXLCZ)99100000000002368020050105d2004 uy 0engur|n|---|||||txtccrOpenOffice.org macros explained[electronic resource] /bAndrew Pitonyak ; edited by C. Pearsall, Jean Weber, Amy BoyerWhitefish Bay , WI Hentzenwerke Publishingc20041 online resource (499 p.)Includes index.1-930919-51-4 ""Our Contract with You, the Reader""; ""List of Chapters""; ""Table of Contents""; ""Acknowledgments""; ""About the Authors""; ""How to Download the Files""; ""Icons Used in this Book""; ""Chapter 1: Getting Started""; ""Storing a macro in a document library""; ""Step 1. Create a library""; ""Step 2. Create a module""; ""Step 3. Enter your first macro""; ""Storing a macro in the application library""; ""The Integrated Development Environment""; ""Using breakpoints""; ""Library management""; ""How libraries are stored""; ""Application libraries""; ""Document libraries""""Using the Macro Organizer""""Renaming modules and libraries""; ""Adding libraries""; ""Conclusion""; ""Chapter 2: Language Constructs""; ""Compatibility with Visual Basic""; ""Variables""; ""Constant, subroutine, function, label, and variable names""; ""Declaring variables""; ""Assigning values to variables""; ""Boolean variables are True or False""; ""Numeric variables""; ""Integer variables""; ""Long Integer variables""; ""Currency variables""; ""Single variables""; ""Double variables""; ""String variables contain text""; ""Date variables""; ""A new way to declare variables""""Create your own data types""""Object variables""; ""Variant variables""; ""Constants""; ""The With statement""; ""Arrays""; ""Changing the dimension of an array""; ""The unexpected behavior of arrays""; ""Subroutines and functions""; ""Arguments""; ""Pass by reference or by value""; ""Optional arguments""; ""Recursive routines""; ""Scope of variables, subroutines, and functions""; ""Local variables defined in a subroutine or function""; ""Variables defined in a module""; ""Global""; ""Public and Dim""; ""Private""; ""Operators""; ""Mathematical and string operators""""Unary plus (+) and minus (-)""""Exponentiation (^)""; ""Multiplication (*) and Division (/)""; ""Remainder after division (MOD)""; ""Integer division (\)""; ""Addition (+), subtraction (-), and string concatenation (& and +)""; ""Logical and bitwise operators""; ""AND""; ""OR""; ""XOR""; ""EQV""; ""IMP""; ""NOT""; ""Comparison operators""; ""Flow control""; ""Define a label as a jump target""; ""GoSub""; ""GoTo""; ""On GoTo and On GoSub""; ""If Then Else""; ""IIf""; ""Choose""; ""Select Case""; ""Case expressions""; ""If Case statements are easy, why are they frequently incorrect?""""Writing correct Case expressions""""While ... Wend""; ""Do ... Loop""; ""Exit the Do Loop""; ""Which Do Loop should I use?""; ""For ... Next""; ""Exit Sub and Exit Function""; ""Error handling using On Error""; ""Ignore errors with On Error Resume Next""; ""Clear an error handler with On Error GoTo 0""; ""Specify your own error handler with On Error GoTo Label""; ""Error handlers�why use them?""; ""Conclusion""; ""Chapter 3: Numerical Routines""; ""Trigonometric functions""; ""Rounding errors and precision""; ""Mathematical functions""; ""Numeric conversions""""Number to string conversions""Integrated softwareBusinessComputer programsIntegrated software.BusinessComputer programs.005.5Pitonyak Andrew(Andrew Douglas)1507637Pearsall CedtWeber Jean HollisedtBoyer AmyedtMiAaPQMiAaPQMiAaPQBOOK9910783282703321OpenOffice.org macros explained3738535UNINA