2020ok  Directory of FREE Online Books and FREE eBooks

Free eBooks > Computers & Internet > Programming > Software Design > Software Development > Mastering Excel 2003 Programming with VBA

Mastering Excel 2003 Programming with VBA

by Steven M. Hansen and Sybex


Download Book
(Respecting the intellectual property of others is utmost important to us, we make every effort to make sure we only link to legitimate sites, such as those sites owned by authors and publishers. If you have any questions about these links, please contact us.)


link 1



About Book

Book Description
Create Powerful Business Applications with Excel 2003

Excel 2003 is an ideal application development platform for all levels of business needs. If you're an advanced Excel user looking to gain programming experience, or a skilled developer new to Excel or the Excel Object Model, this no-nonsense book teaches you how to build custom applications that can generate substantial time and cost savings for you, your employer, and your customers.

Written by a professional with nearly a decade of experience producing Excel/VBA solutions, Mastering Excel 2003 Programming with VBA conveys the precise knowledge and techniques you need to be highly productive. You'll master the most critical Excel objects and development practices necessary to create a complete solution, including working with XML data, Smart Document technology, and database integration with ADO. And you can readily apply the practical advice and reusable code examples to your own projects.

In his friendly style, author Steven Hansen makes the information easy to grasp and entertaining to read, and he does not shy away from challenging material. You'll learn all about:
* Ramping up with VBA
* Debugging tools and tactics that work
* Mastering the Excel Object Model
* Developing class modules
* Customizing Excel UserForms
* Integrating Excel with other applications
* Incorporating text files in your solution
* Coding solutions that leverage a database
* Using XML in Excel
* Designing user-friendly toolbars and menus
* Building Excel 2003 Smart Documents
* Deploying your solution

From the Back Cover
Create Powerful Business Applications with Excel 2003

Excel 2003 is an ideal application development platform for all levels of business needs. If you're an advanced Excel user looking to gain programming experience, or a skilled developer new to Excel or the Excel Object Model, this no-nonsense book teaches you how to build custom applications that can generate substantial time and cost savings for you, your employer, and your customers.

Written by a professional with nearly a decade of experience producing Excel/VBA solutions, Mastering Excel 2003 Programming with VBA conveys the precise knowledge and techniques you need to be highly productive. You’ll master the most critical Excel objects and development practices necessary to create a complete solution, including working with XML data, Smart Document technology, and database integration with ADO. And you can readily apply the practical advice and reusable code examples to your own projects.

In his friendly style, author Steven Hansen makes the information easy to grasp and entertaining to read, and he does not shy away from challenging material. You’ll learn all about:

  • Ramping up with VBA
  • Debugging tools and tactics that work
  • Mastering the Excel Object Model
  • Developing class modules
  • Customizing Excel UserForms
  • Integrating Excel with other applications
  • Incorporating text files in your solution
  • Coding solutions that leverage a database
  • Using XML in Excel
  • Designing user-friendly toolbars and menus
  • Building Excel 2003 Smart Documents
  • Deploying your solution


About the Author
Steven Hansen has been developing analytical software applications since 1997, and founded Dakota Technology Group, Inc., in 1998. Most of the software he develops uses Excel. He also offers training geared towards increasing the efficiency of analysts. Prior to 1997, Steve was a financial analyst using VBA with Excel to perform sophisticated analyses and to automate analytical processes. He has a BA degree in history from Rollins College and an MBA degree from the University of Minnesota.

Comments

it is a very useful book

SEND A COMMENT

PLEASE READ: All comments must be approved before appearing in the thread; time and space constraints prevent all comments from appearing. We will only approve comments that are directly related to the article, use appropriate language and are not attacking the comments of others.

Message (please, no HTML tags. Web addresses will be hyperlinked):

Related Free eBooks

Related Tags

DIGG This story   Save To Google   Save To Windows Live   Save To Del.icio.us   diigo it   Save To blinklist
Save To Furl   Save To Yahoo! My Web 2.0   Save To Blogmarks   Save To Shadows   Save To stumbleupon   Save To Reddit