TY  - BOOK
AU  - Jelen,Bill
AU  - Syrstad,Tracy
ED  - Safari eBooks.
TI  - VBA and macros for Microsoft Office Excel 2007
SN  - 9780789736826
PY  - 2007///
KW  - Microsoft Excel (Computer file)
KW  - Microsoft Visual Basic for applications
KW  - Business
KW  - Computer programs
KW  - Electronic spreadsheets
KW  - Electronic books
KW  - local
N1  - Includes index; Unleash 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; Electronic reproduction; Boston, Mass.; Safari Books Online; 2007; Mode of access: World Wide Web; Available to subscribing institutions
UR  - http://ezproxy.alfaisal.edu/login?url=http://academic.safaribooksonline.com/?uiCode=sdl&xmlId=9780789736826
ER  -