Excel VBA Macro Programming

Make Excel work harder and faster for you. This unique book presents sample code for more than twenty practical, high-powered Excel VBA macro applications. You'll get all the essentials of VBA, and then explore ways to power Excel with VBA. Automate tasks, convert numbers to labels, transpose cells, add formula details, globally changes values, and much, much more.

In the last forty years, at least fifty books have been written on the subject of soil mechanics, most of them textbooks. Only a few touch on practical applications. Soil Engineering: Testing, Design, and Remediation supplies the information needed to fill the gap between textbook learning and practical know-how.
When engineers deal with major projects, such as the Teton Dam or the Leaning Tower of Pisa, they need high-tech solutions. More often than not, however, they deal with the foundations for warehouses, schools, medium-rise buildings, and residential structures, projects that need low-tech solutions. Ninety percent of the time consulting engineers don't require mathematical treatment or computer analysis, they require experience.
Soil engineering problems cannot be resolved with textbook information alone. This book provides the practical meaning of the different aspects of soil mechanics, the use of unconfined compression test data, the meaning of consolidated tests, the practical value of lateral pressure, and more. In addition to the technical aspects of foundation investigation, in the real world the shadow of litigation looms over every consultant's head. The author covers legal issues in detail.
After several years in foundation investigation most consultants realize that soil engineering is a combination of art and science. Soil Engineering: Testing, Design and Remediation demystifies this connection and supplies real-world examples of practical applications. This hands-on, ready reference will be essential tool for any consultant working in the field.

"...provides recent case histories, up-to-date information and how to guidelines...includes the use of unconfined compression test data, the meaning of consolidation tests & the practical values of lateral pressure."

Develop powerful, custom Excel applications using Visual Basic for Applications

Maximize the features and functionality of Excel with help from this unique resource designed specifically for power users. Inside, you’ll find complete details on Excel VBA programming and application development—from the fundamentals to advanced techniques. Then, you’ll get 21 real-world projects, complete with working code, so you can create Excel VBA macros right away. These projects include everything from setting up timed events to auto totaling a matrix of numbers to altering the appearance of spreadsheet components—and much more.

• Write and debug VBA code
• Create custom dialog boxes and toolbars
• Take advantage of the Excel object model
• Write code to interact with a database
• Use application programming interface (API) calls
• Create and use class modules
• Develop unique menus within the Excel menu structure
• Expand calculation and search functions
• Write macros for customized worksheets
• Create full-fledged Excel add-ins

ABOUT THE AUTHOR: Richard Shepherd has been developing software for blue-chip corporations for 20 years. He has produced VBA code in Excel for major projects, including profit-and-loss reporting and business planning and budgeting.

Richard Shepherd (Reading, Berkshire, England) is a qualified accountant with a special interest in computer languages, particularly Visual Basic, and he’s spent the last 20 years developing computer software in blue chip organizations.

Master Oracle E-Business Suite's Oracle Procure-to-Pay Drive better decision making and maximize asset usage with Oracle E-Business Suite's comprehensive end-to-end procurement solution. This Oracle Press guide details, step-by-step, how to streamline and optimize your enterprise acquisition cycle using Oracle Procure-to-Pay. Set up and configure each module, generate contracts and purchase orders (POs), perform automatic invoicing, process payments, and enforce fiscal policies. You will also learn how to use powerful new purchasing and payables features. Manage POs and strengthen policy compliance using Oracle Purchasing Track documents from the buyers work center and demand workbench Centralize requisition creation and approvals Create and use sourcing rules for supplier purchases Use Oracle Payables to process invoices and handle settlements Consolidate and disburse funds using Oracle Payments Understand key setups for Oracle Purchasing, Oracle Payables, and Oracle Payments Publisher's Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product. Develop powerful, custom Excel applications using Visual Basic for Applications Maximize the features and functionality of Excel with help from this unique resource designed specifically for power users. Inside, youll find complete details on Excel VBA programming and application development--from the fundamentals to advanced techniques. Then, youll get 21 real-world projects, complete with working code, so you can create Excel VBA macros right away. These projects include everything from setting up timed events to auto totaling a matrix of numbers to altering the appearance of spreadsheet components--and much more. Publisher's Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product. Master Oracle E-Business Suite's Oracle Procure-to-Pay Drive better decision making and maximize asset usage with Oracle E-Business Suite's comprehensive end-to-end procurement solution. This Oracle Press guide details, step-by-step, how to streamline and optimize your enterprise acquisition cycle using Oracle Procure-to-Pay. Set up and configure each module, generate contracts and purchase orders (POs), perform automatic invoicing, process payments, and enforce fiscal policies. You will also learn how to use powerful new purchasing and payables features. "After several years in foundation investigation most consultants realize that soil engineering is a combination of art and science. Soil Engineering: Testing, Design, and Remediation demystifies this connection and supplies real-world examples of practical applications. This hands-on, ready reference is an essential tool based on the life's work of a well-respected engineer."--BOOK JACKET. "Soil engineering problems cannot be resolved with textbook information alone. This book provides the practical meaning of the different aspects of soil mechanics, the use of unconfined compression test data, the meaning of consolidated tests, the practical value of lateral pressure, and more."--Jacket This book provides consulting engineers with the practical meaning of the various aspects of soil mechanics. Chen, author of the classic "Foundations of Expansive Soil" provides recent case histories, up-to-date information, and "how to" guidelines. This comprehensive treatment of soil engineering includes: the use of unconfined compression test data, the meaning of consolidation tests, and the practical values of lateral pressure A practical manual for developers seeking to maximize the power of Excel by using VBA programs to create macros to save time and effort guides readers through a number of practical projects and discusses such topics as VBA basics, debugging, VBA-powered Excel, Dialog control, command bars and buttons, API calls, animation, and more. Original. (Advanced) Site investigation Subsoil exploration Field tests Classification and identification Laboratory soil tests Foundation design Footings on clay Footings on sand Footings on fill Pier foundations Laterally loaded piers Driven pile foundations Drainage Slope stability Distress investigations Construction Legal aspects Report writing. Covers the latest version of the software including its most innovative new features, instructing users on such topics as the business considerations of Oracle's Procurement-to-Pay implementation, setup requirements, and processing completions. This text was written for Power users who want to maximize the power of Excel by using VBA programmes to create time and effort saving macros. It should allow users to do basic programming right away The stability and performance of a structure founded on soil depend on the subsoil conditions, ground surface features, type of construction, and sometimes the meteorological changes.