LEADER 04714nam 2200637Ia 450 001 9910783282703321 005 20230617030339.0 010 $a1-280-54428-7 010 $a9786610544288 010 $a1-930919-52-2 035 $a(CKB)1000000000023680 035 $a(EBL)3301811 035 $a(SSID)ssj0000282501 035 $a(PQKBManifestationID)11225072 035 $a(PQKBTitleCode)TC0000282501 035 $a(PQKBWorkID)10317222 035 $a(PQKB)10089608 035 $a(MiAaPQ)EBC3301811 035 $a(Au-PeEL)EBL3301811 035 $a(CaPaEBR)ebr10120756 035 $a(CaONFJC)MIL54428 035 $a(OCoLC)560106499 035 $a(EXLCZ)991000000000023680 100 $a20050105d2004 uy 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 10$aOpenOffice.org macros explained$b[electronic resource] /$fbAndrew Pitonyak ; edited by C. Pearsall, Jean Weber, Amy Boyer 210 $aWhitefish Bay , WI $cHentzenwerke Publishing$dc2004 215 $a1 online resource (499 p.) 300 $aIncludes index. 311 $a1-930919-51-4 327 $a""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"" 327 $a""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"" 327 $a""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"" 327 $a""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?"" 327 $a""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 handlersa???why use them?""; ""Conclusion""; ""Chapter 3: Numerical Routines""; ""Trigonometric functions""; ""Rounding errors and precision""; ""Mathematical functions""; ""Numeric conversions"" 327 $a""Number to string conversions"" 606 $aIntegrated software 606 $aBusiness$xComputer programs 615 0$aIntegrated software. 615 0$aBusiness$xComputer programs. 676 $a005.5 700 $aPitonyak$b Andrew$g(Andrew Douglas)$01507637 702 $aPearsall$b C$4edt 702 $aWeber$b Jean Hollis$4edt 702 $aBoyer$b Amy$4edt 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910783282703321 996 $aOpenOffice.org macros explained$93738535 997 $aUNINA