How we did it:
For any feedback, any questions, any notes or just for chat - feel free to follow us on social networks
Rob Bovey, Stephen Bullen, Dennis Wallentin
A guide to the development aspects of Excel covers such topics as building add-ins, creating custom charts, using class modules, handling errors, controlling external applications, and programming with databases.
Matthew J. Curland
In Advanced Visual Basic 6, leading Visual Basic expert Matthew Curland demonstrates powerhouse techniques programmers can use to write high-performance, robust, and reusable VB code. Readers learn how to leverage the close relationships between VB, COM, and OLE Automation, extending the envelope of VBs capabilities and building high-quality, object-based systems./P> Key topics include how to: *Control VB array variables explicitly to directly access arbitrary memory locations *Call pointers to standard, cdecl, and class module functions *Aggregate complete interface implementations into any VB object *Override functions on any interface, including those implemented automatically by VB *Turn any user-defined type into a lightweight COM object *Minimize memory usage in systems with a large number of objects *Safely create and manage threads in ActiveX EXEs and DLLs *Interact with messages to customize windowed and windowless UserControl objects The CD-ROM accompanying this book contains extensive source code samples to enable all techniques without external DLLs. It also provides integrated type library add-ins for creating and editing referenced libraries, modifying binary compatib
Paul Litwin, Ken Getz, Mike Gunderloy
Expert Instruction. Advanced Coverage. An Unbeatable Price. This two-volume set provides you with the two most advanced guides to Access development at a significantly reduced price. Inside, you'll find unparalleled instruction from three internationally recognized Access experts, covering the full range of Access desktop and enterprise applications. Filled with scores of practical examples illustrating effective, elegant solutions to real-world challenges, these books provide the skills you need to be a professional Access developer. Access 2002 Desktop Developer's Handbook Design and Build Access Databases for Single Users and Small Workgroups Design Forms and Reports That Meet Users' Exact Needs Take Full Advantage of the Latest Access Functionality, Including New PivotTable and Pivot Chart Views and New Programmability Features Access 2002 Enterprise Developer's Handbook Publish Data on the Web with Data Access Pages Take Advantage of Improved SQL Server Integration and XML Support Tackle the Toughest Replication and Security Challenges Put the New Office Web Components to Work in Your Access Applications
Paul Litwin, Ken Getz, Mike Gunderloy
DESIGN, BUILD, AND REFINE ACCESS APPLICATIONS THAT MEET YOUR ORGANIZATION'S SPECIAL NEEDS The latest from internationally recognized Access authorities Litwin, Getz, and Gunderloy, Access 2002 Desktop Developer's Handbook offers complete coverage of every aspect of building Access applications for single users and small workgroups. Inside, you'll find scores of practical examples, carefully devised by the authors to illustrate effective, elegant solutions to real-world challenges. Coverage includes * Understanding the Access event model * Using VBA class modules * Applying sound database design principles * Using Access SQL * Controlling controls * Using ActiveX Data Objects (ADO) * Designing effective forms and reports * Taking advantage of shared Office programmability * Controlling your printer * Using Access as an automation client and server * Debugging and handling errors * Optimizing your application * Accessing DLLs and the Windows API * Adding professional features offered by Access Wizards * Building COM add-ins and MDA files * Using Reddick VBA naming conventions
Paul Litwin, Ken Getz, Mike Gunderloy
Microsoft Access is a home and small office database, and is used as a front end to Microsoft's SQL Server database. This text covers forms, reports, database design, building add-ins, and working with the Windows API.
Teresa Hennig, Rob Cooper, Geoffrey L. Griffith
A comprehensive resource on the use of VBA for building Access applications furnishes real-world code examples to demonstrate each programming topic, including the Access Object Model, using VBA with ADO, VBA Execution and Error Handling, the Windows Registry, ADE Tools, security issues, and using VBA with SQL, among others. Original. (Intermediate)
This guide covers the upgraded features of Access 97, including Internet connections, Visual Basic for Applications (VBA) imnprovements, object linking and embedding (OLE) secrets, and error and debugging tools. The CD contains all examples from the book, including databases; reusable code; and subroutines and user-interface objects. Also included are freeware and shareware utilities, as well as demonstration versions of third-party utilities.
Ken Getz, Paul Litwin, Mike Gilbert
Annotation This upgrade to the popular database product includes Internet connections, spectacular Visual Basic for Applications (VBA) improvements, Object Linking and Embedding (OLE) secrets, and error and debugging tools.
Richard M. Heiberger, Erich Neuwirth
In this book, the authors build on RExcel, a free add-in for Excel that can be downloaded from the R distribution network. RExcel seamlessly integrates the entire set of R's statistical and graphical methods into Excel, allowing students to focus on statistical methods and concepts and minimizing the distraction of learning a new programming language.
The most comprehensive guidebook available on the most popular spreadsheet program, fully updated to include all-new "X" features Written by the leading Excel guru known as "Mr. Spreadsheet," John Walkenbach, who has written more than thirty books and 300 articles on related topics and maintains the popular Spreadsheet Page at www.j-walk.com/ss The definitive reference book for beginning to advanced users, featuring expert advice and hundreds of examples, tips, techniques, shortcuts, work-arounds, and more Covers expanded use of XML and Web services to facilitate data reporting, analysis, importing, and exporting information Explores Excel programming for those who want advanced information CD-ROM includes all templates and worksheets used in the book, as well as sample chapters from all Wiley Office "X" related Bibles and useful third party software, including John Walkenbach's Power Utility Pak Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.
Today’s learners master both basic and advanced skills in Visual Basic for Applications (VBA), the programming language for Microsoft Office, with this essential tool. Albright’s VBA FOR MODELERS: DEVELOPING DECISION SUPPORT SYSTEMS WITH MICROSOFT OFFICE EXCEL, 5E teaches how to automate common spreadsheet tasks as well as create the sophisticated management science applications needed in business today. The first half of the book introduces readers to the fundamentals of VBA for Excel. The second half of the book puts knowledge into action as it illustrates how to automate a number of management science models using VBA. Students learn to develop clean code and user-friendly interfaces for inputs and results. A new section familiarizes readers with PowerPivot and the new Excel Data Model. Novices as well as more experienced professionals will find the skills and background they need to maximize their VBA skills. Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version.
Want to get the most out of Access? Then you need to know VBA. Access 2000 is here, and never has the power of Access depended so much on VBA programming. This makes the Access 2000 VBA Handbook essential reading if you want to use Microsoft's popular database product to its full advantage. If you're an Access user, you'll benefit from step-by-step coverage of VBA basics that will simplify your work. If you're a developer, you'll master the high-end techniques introduced in the latest release-so you can stay on top of your job. You'll learn how to: * Create databases and projects * View and print reports * Run queries to find specific records * Automate complex and time-consuming procedures * Synchronize forms and tables * Understand the ADO and DAO models * Customize the user interface * Access data using OLE DB and ODBC * Create VBA procedures for navigating a database or project * Use object properties and methods to write VBA procedures * Create relationships between forms * Execute commands using SQL statements in VBA code * Use ActiveX controls in your VBA procedures
Gunter Löeffler, Mr Peter N Posch
This book provides practitioners and students with an intuitive, hands-on introduction to modern credit risk modelling. Every chapter starts with an explanation of the methodology and then the authors take the reader step by step through the implementation of the methods in Excel and VBA.