Excel users. Access users. You're probably among the majority, living in one camp or the other but rarely crossing between the two. Yet Microsoft designed these applications to work together. In this book, you'll discover how Access benefits from Excel's flexible presentation layer and versatile analysis capabilities, while Access's relational database structure and robust querying tools enhance Excel. Once you learn to make the team work, you'll find that your team's productivity is the real winner.

* Move data easily between Excel and Access
* Store Excel data in a structured relational database
* Create Excel PivotTables with Access data
* Report Access data using Excel's presentation layer
* Use VBA, ADO, and SQL to move data from one application to the other
* Save time and increase productivity by automating redundant processes with VBA
* Simplify integration tasks using XML
* Integrate Excel data into other Office applications

Author(s): Duane Birnbaum
Publisher: Thomson
Year: Mar 2005
ISBN: 1592007295
Language: English
Pages: 504
File type: PDF
Size : 6 MB

Visual Basic For Application (VBA for short) is a programming environment designed to work with MS Office applications (Word, Excel, Access and Power Point). components in each application (for example, worksheets or documents) are exposed as objects to the programmer to use and manipulate to a desired end. Almost anything you cand do through the normal use of the Office application can also be automated thourgh programming.

VBA is a complete programming language, but you can't use it outside the application in which it is integrated. This does not mean VBA can be integrated only with Office programs. Any software vendor that decides to implement VBA can include it with their application.

VBA is relatively easy to learn, but to use it in a new application, you must first become familiar with the "object model" of the application. For example, the "Document" and "Dictionary" objects are specific to the Word object mode, whereas the "workbook", "Worksheet" and "Range" objects are specific to the Excel object model. As you proceed through this book, you will see that the Excel Object model is faifly extensive; however, if you are familiar with Excel, you will find that using theese objects is generally straightforward.

This book uses real-world examples to give you a context in which to use the task. This book also includes workshops to help you put together individual tasks into projects. The PowerPoint example files that you need for project tasks are available at www.perspection.com.

Containing 277 business case studies that illustrate nearly every aspect of Excel, this book presents real-life business problems and works them through to their solutions. In addition to exemplary solutions, each case analysis considers alternate approaches and gotchas, and includes a summary of the necessary commands and functions. Excel files that can be downloaded and worked through step-by-step are included for each case This is one of those books that don’t really contain anything new. What they do instead is present things in a way that as you read it you tend to say ‘Of course, that’s the way I can do that.’ For instance, suppose you want to sort a spreadsheet on only the first three digits of an account number. You turn to page 147. It says, ‘Create a new column. Use the LEFT function to populate that column. Sort on the new column.’ It actually show you more instruction on how to do this, but that’s the idea. ‘Of course, you say, how obvious.’ Then why didn’t you think of it first? To make it easier to find what you’re looking for, the book is broken into four sections: The Excel Environment, Calculating with Excel, Wrangling Data, Making Things Look Good. Each section then has a bunch of these ‘hints & tips’ I guess I’d call them. Alternatively there’s a fairly complete index that is organizated alphabetically rather than functionally. I rank this an an excellent intermediate level book. If you don’t know what a spreadsheet does, you need a lower level book. If you want to learn about Macros and VBA, you want a higher level. But regardless of your level, you’ll find at least a few ‘Of course’s.’

Author(s): Loren Abdulezer
Publisher: Wiley
Year: 2006
ISBN:
Language: English
File type: PDF
Pages: 434
Size (for download): 7.54 MB

Spreadsheets are among the most widely used and useful programs on the planet. Despite the popularity of spreadsheets, people face constant challenges in using them. Escape From Excel Hell is your guide to troubleshooting them.

The problems I have selected for Escape From Excel Hell are based on commonly encountered problems that appear on community bulletin boards, listservs, and newsgroups. I researched well over 10,000 of them. Although there is a wide diversity of problems, a great many of them are repeatedly asked.