000 02031nam a2200313 a 4500
005 20260112063233.0
020 _a8131719879
039 _a201301230147
_bstaff
_c200908040336
_d staff
_y 200908040335
_z staff
050 _a005.54E2007
_bJEL
082 _a005.54E2007
_bJEL [ Shelf 8]
100 _aJelen, Bill.
245 _aVBA and macros for Microsoft Office Excel 2007 /
_cBill "MrExcel" Jelen, Tracy Syrstad.
246 _aVisual Basic for applications and macros for Microsoft Office Excel 2007
250 _a[2nd ed.]
260 _aIndianapolis, Ind. :
_bQue,
_cc2008.
300 _axxiii, 598 p. :
_bill. ;
_c24 cm.
440 _aBusiness solutions
500 _aIncludes index.
505 _aUnleash the power of Excel with VBA -- This sounds like BASIC, so why doesn't it look familiar? -- Referring to ranges -- User-defined functions -- Looping and flow control -- R1C1-style formulas -- What's new in Excel 2007 and what's changed -- Create and manipulate names in VBA -- Event programming -- Userforms--an introduction -- Creating charts -- Data mining with advanced filter -- Excel power -- Data visualizations and conditional formatting -- Reading from and writing to the Web -- XML in Excel 2007 -- Automating Word -- Arrays -- Text file processing -- Using Access as a back end to enhance multi-user access to data -- Creating classes, records, and collections -- Advanced userform techniques -- Windows application programming interface (API) -- Handling errors -- Customizing the ribbon to run macros -- Creating add-ins.
630 _aMicrosoft Excel (Computer file)
630 _aMicrosoft Visual Basic for applications.
650 _aBusiness
_x Computer programs.
650 _aElectronic spreadsheets.
700 _aSyrstad, Tracy.
856 _Table of contents only
_u http://www.loc.gov/catdir/toc/ecip0720/2007024410.html
991 _aVIRTUA40
991 _aVTLSSORT0080*0200*0500*0820*1000*2450*2460*2500*2600*3000*4400*5000*5050*6300*6301*6500*6501*7000*8560*9992
909 _a1154
999 _c1139
_d1139