Free ebooks download engine

This book is aimed squarely at Excel users who want to harness the power of the VBA language in their Excel applications. At all times, the VBA language is presented in the context of Excel, not just as a general application programming language.

The Primer has been written for those who are new to VBA programming and the Excel object model. It introduces the VBA language and the features of the language that are common to all VBA applications. It explains the relationship between collections, objects, properties, methods, and events and shows how to relate these concepts to Excel through its object model. It also shows how to use the Visual Basic Editor and its multitude of tools, including how to obtain help.

The middle section of the book takes the key objects in Excel and shows, through many practical examples, how to go about working with those objects. The techniques presented have been developed through the exchange of ideas of many talented Excel VBA programmers over many years and show the best way to gain access to workbooks, worksheets, charts, ranges, and so on. The emphasis is on efficiency—that is, how to write code that is readable and easy to maintain and that runs at maximum speed. In addition, the chapters devoted to accessing external databases detail techniques for accessing data in a range of formats.

The final four chapters of the book address the following advanced issues: linking Excel to the Internet, writing code for international compatibility, programming the Visual Basic Editor, and how to use the functions in the Win32 API (Windows 32-bit Application Programming Interface).

TABLE OF CONTENT:
Chapter 01 - Primer in Excel VBA
Chapter 02 - The Application Object
Chapter 03 - Workbooks and Worksheets
Chapter 04 - Using Ranges
Chapter 05 - Using Names
Chapter 06 - Filtered Lists
Chapter 07 - PivotTables
Chapter 08 - Charts
Chapter 09 - Event Procedures
Chapter 10 - Adding Controls
Chapter 11 - Text Files and File Dialog
Chapter 12 - Working with XML and the Open XML File Formats
Chapter 13 - UserForms
Chapter 14 - RibbonX
Chapter 15 - Command Bars
Chapter 16 - Class Modules
Chapter 17 - Add-ins
Chapter 18 - Automation Add-ins and COM Add-ins
Chapter 19 - Interacting with Other Office Applications
Chapter 20 - Data Access with ADO
Chapter 21 - Managing External Data
Chapter 22 - The Trust Center and Document Security
Chapter 23 - Browsing OLAP Data Sources with Excel
Chapter 24 - Excel and the Internet
Chapter 25 - International Issues
Chapter 26 - Programming the VBE
Chapter 27 - Programming with the Windows API

This version of the Server Bible will be the largest yet, catering to what is certainly the most advanced operating system introduced by Microsoft. The book will cater to the needs of the server administration community and will be designed to be a critical reference. The book will extensively cover the most notable new feature of Windows Server known as the “Server Core.” Server Core is a significantly scaled-back installation where no graphical shell (explorer.exe) is installed, and all configuration and maintenance is done entirely through the command-line windows, or by connecting to the machine remotely using Microsoft Management Console. Server Core will also not include the .NET Framework, Internet Explorer or many other features not related to core server features. A Server Core machine can be configured for four basic roles: Domain controller, DNS Server, DHCP Server, and file server. Chapters on setup and installation will also cover the new componentized operating system Image-based setup and deployment tools, using WIM.

IBM’s DB2 Express Edition is one of the most capable of the free database platforms available in today’s marketplace. In Beginning DB2, author Grant Allen gets you started using DB2 Express Edition for web sites, desktop applications, and more. The author covers the basics of DB2 for developers and database administrators, shows you how to manage data in both XML and relational form, and includes numerous code examples so that you are never in doubt as to how things work.

You don’t have to be a master programmer to build great Web pages! This book shows you what HTML is about and how to use XHTML to format great-looking pages. Then you’ll see how CSS helps you manipulate colors, fonts, and more. You can even add scripting languages and build interactive pages — here’s how!
Discover how to:
Plan your Web site to prevent problems
Use the proper syntax for HTML and XHTML
Build a company Web site
Upload and publish Web pages
Integrate scripts with XHTML
Test and debug your Web page

If you’re a PHP developer, you can build Rails-like applications without learning a new language by following the hands-on tutorials in Professional CodeIgniter. In this book, find an overview of MVC and agile technologies, model and schema for products, helpers and libraries, Ajax and Scriptaculous, and explanations of the creation of applications like content management, blogs, and forums. Follow the step-by-step instructions for building and perfecting each application with CodeIgniter, and you will learn how to avoid everyday problems that other reference manuals don’t address.

Playing an integral role in the Windows Server administration, Active Directory (AD) allows users to configure groups, implement network security, create and enforce network policies, and more
This friendly introduction to AD provides system administrators with the basics of AD and points them in the right direction for setting up a network schema, helping them avoid common AD mistakes that can undermine network security
New material includes coverage of security improvements, significant user interface changes, and updates to the AD scripting engine, password policies, accidental object deletion protection, and more