Microsoft® Office Excel 2003 Programming Inside Out (eBook)

by (Author)

  • 192,502 Words

You’re a sophisticated user of Excel—a real pro with spreadsheets—so now dig into its powerful programming capabilities and really put your data to work! From writing code in Microsoft Visual Basic for Applications (VBA) to taking advantage of new XML data-sharing features, this book packs hundreds of timesaving programming solutions, troubleshooting tips, and handy workarounds all in concise, fast-answer format. Discover the best and fastest ways to build custom business solutions with Excel—and challenge yourself to new levels of mastery!From automating simple tasks to building custom solutions, write better code with VBALearn best practices for writing and debugging your own macrosUse VBA code to manage dates and times, reformat worksheets, and locate external filesExtend your Excel solutions by developing your own add-insGet powerful perspectives on data by programmatically manipulating PivotTable and PivotChart dynamic viewsCreate custom command bars, dialog boxes, and user formsEmploy ActiveX Data Objects (ADO) to access external databasesExploit the new XML capabilities in Excel 2003CD features:Complete eBook in PDF formatInsider Extras—including all the authors’ sample files and codeCatalog of Excel resources with links to third-party tools and demosMicrosoft resources and demos, including Insider’s Guide to Microsoft Office OneNote 2003 eBookFREE! Microsoft Computer Dictionary, Fifth Edition, eBook—10,000+ entriesA Note Regarding the CD or DVDThe print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com.

You’re a sophisticated user of Excel—a real pro with spreadsheets—so now dig into its powerful programming capabilities and really put your data to work! From writing code in Microsoft Visual Basic for Applications (VBA) to taking advantage of new XML data-sharing features, this book packs hundreds of timesaving programming solutions, troubleshooting tips, and handy workarounds all in concise, fast-answer format. Discover the best and fastest ways to build custom business solutions with Excel—and challenge yourself to new levels of mastery!From automating simple tasks to building custom solutions, write better code with VBALearn best practices for writing and debugging your own macrosUse VBA code to manage dates and times, reformat worksheets, and locate external filesExtend your Excel solutions by developing your own add-insGet powerful perspectives on data by programmatically manipulating PivotTable and PivotChart dynamic viewsCreate custom command bars, dialog boxes, and user formsEmploy ActiveX Data Objects (ADO) to access external databasesExploit the new XML capabilities in Excel 2003CD features:Complete eBook in PDF formatInsider Extras—including all the authors’ sample files and codeCatalog of Excel resources with links to third-party tools and demosMicrosoft resources and demos, including Insider’s Guide to Microsoft Office OneNote 2003 eBookFREE! Microsoft Computer Dictionary, Fifth Edition, eBook—10,000+ entriesA Note Regarding the CD or DVDThe print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com.


  • 0
    0
  • 1
    1
  • 2
    2
  • 3
    3
  • 4
    4
  • 5
    5
  • 6
    6
  • 7
    7
  • 8
    8
  • 9
    9
  • 0
    0
  • 1
    1
  • 2
    2
  • 3
    3
  • 4
    4
  • 5
    5
  • 6
    6
  • 7
    7
  • 8
    8
  • 9
    9
  • 0
    0
  • 1
    1
  • 2
    2
  • 3
    3
  • 4
    4
  • 5
    5
  • 6
    6
  • 7
    7
  • 8
    8
  • 9
    9
:
  • 0
    0
  • 1
    1
  • 2
    2
  • 3
    3
  • 4
    4
  • 5
    5
  • 6
    6
  • 7
    7
  • 8
    8
  • 9
    9
  • 0
    0
  • 1
    1
  • 2
    2
  • 3
    3
  • 4
    4
  • 5
    5
  • 6
    6
  • 7
    7
  • 8
    8
  • 9
    9
:
  • 0
    0
  • 1
    1
  • 2
    2
  • 3
    3
  • 4
    4
  • 5
    5
  • 6
    6
  • 7
    7
  • 8
    8
  • 9
    9
  • 0
    0
  • 1
    1
  • 2
    2
  • 3
    3
  • 4
    4
  • 5
    5
  • 6
    6
  • 7
    7
  • 8
    8
  • 9
    9
Average Reading Time Login to Personalize

Microsoft® Office Excel 2003 Programming Inside Out

No reviews were found. Please log in to write a review if you've read this book.

Item added to cart

9780735637375 bookshelf
Microsoft® Office Exce...
$39.99
QTY: 1

9780735637375 bookshelf

Write a Review for Microsoft® Office Excel 2003 Programming Inside Out

by Curtis Frye, Wayne S. Freeze, Felicia K. Buckingham

Average Rating:
×

Microsoft® Office Excel 2003 Programming Inside Out has been added

Microsoft® Office Excel 2003 Programming Inside Out has been added to your wish list.

Ok