VBA and Macros for Microsoft Office Excel 2007 /
Jelen, Bill.
VBA and Macros for Microsoft Office Excel 2007 / Visual Basic for Applications and Macros for Microsoft Office Excel 2007 Bill "MrExcel" Jelen, Tracy Syrstad. - [2nd ed.] - Indianapolis, Ind. : Que, c2008. - xxiii, 598 p. : ill. ; 24 cm. - Business solutions .
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.
0789736829 9780789736826
2007024410
Microsoft Excel (Computer file)
Microsoft Visual Basic for applications.
Business--Computer programs.
Electronic spreadsheets.
HF5548.4.M523 / J457 2008
005.54 / JEL
VBA and Macros for Microsoft Office Excel 2007 / Visual Basic for Applications and Macros for Microsoft Office Excel 2007 Bill "MrExcel" Jelen, Tracy Syrstad. - [2nd ed.] - Indianapolis, Ind. : Que, c2008. - xxiii, 598 p. : ill. ; 24 cm. - Business solutions .
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.
0789736829 9780789736826
2007024410
Microsoft Excel (Computer file)
Microsoft Visual Basic for applications.
Business--Computer programs.
Electronic spreadsheets.
HF5548.4.M523 / J457 2008
005.54 / JEL