VB & VBA in a Nutshell

The Language

Author: Paul Lomax

Publisher: "O'Reilly Media, Inc."

ISBN: 9781565923584

Category: Computers

Page: 633

View: 5868

Collects and defines the programming languages' statements, procedures, and functions, covering syntax, standard code conventions, differences of operation, data type, undocumented behaviors, and practical applications

VB.NET Language in a Nutshell

A Desktop Quick Reference

Author: Steven Roman,Ronald Petrusha,Paul Lomax

Publisher: "O'Reilly Media, Inc."

ISBN: 9780596003081

Category: Computers

Page: 662

View: 4689

Explains how Visual BASIC has been altered to work within the .NET framework and provides information about topics such as syntax, keyword operations, accepted arguments, and undocumented behaviors of VB.NET.

Visual Basic Controls in a Nutshell

The Controls of the Professional and Enterprise Editions

Author: Evan S. Dictor

Publisher: Oreilly & Associates Incorporated

ISBN: 9781565922945

Category: Computers

Page: 748

View: 9671

A guide for intermediate to advanced programmers documents the programming language's intrinsic and custom controls while exploring the interaction of Visual Basic's forms, modules, and classes

VBScript in a Nutshell

Author: Paul Lomax,Matt Childs,Ron Petrusha

Publisher: "O'Reilly Media, Inc."

ISBN: 0596004885

Category: Computers

Page: 491

View: 6865

Lightweight yet powerful, VBScript from Microsoft® is used in four main areas: server-side web applications using Active Server Pages (ASP), client-side web scripts using Internet Explorer, code behind Outlook forms, and automating repetitive tasks using Windows Script Host (WSH). VBScript in a Nutshell, Second Edition delivers current and complete documentation for programmers and system administrators who want to develop effective scripts. Completely updated for VBScript 5.6, WSH 5.6 and ASP 3.0, VBScript In a Nutshell, Second Edition includes updated introductory chapters that will help you keep current with the significant changes since the first edition was published. New chapters introduce the Windows Script Component for creating binary COM components, and the Script Encoder. The main part of the book is a comprehensive reference focusing on VBScript essentials with an alphabetical reference to all statements, keywords and objects, and a section of notes and solutions to real-world gotchas--various undocumented behaviors and aspects of the language--to help you avoid potential problems. Each entry in the reference section details the following: The keyword's syntax, using standard code conventions A list of arguments accepted by the function or procedure, if any exist A discussion of how and where the keyword should be used within the scripting environment A discussion of the differences between the operation of the keyword in Visual Basic or VBA and in VBScript Regardless of your level of experience programming with VBScript, VBScript in a Nutshell, Second Edition is the book you'll want by your side--the most complete, up-to-date, and easy-to-use language reference available.

Visual Basic 2005 in a Nutshell

Author: Tim Patrick,Paul Lomax,Ron Petrusha

Publisher: "O'Reilly Media, Inc."

ISBN: 059610152X

Category: Computers

Page: 746

View: 6156

The classic Nutshell guide to Microsoft's Visual Basic programming language is completely revised and reorganized to cover the forthcoming VB 3005 version, as well as VB .NET 1.1.

Learning VBScript

Author: Paul Lomax

Publisher: "O'Reilly Media, Inc."

ISBN: 9781565922471

Category: Computers

Page: 598

View: 5951

Examining the differences between VBScript and JavaScript, this introductory tutorial illustrates how to implement the new ActiveX components using VBScript. Above all, it gives a proficient grounding and understanding of VBScript, allowing readers to create more complex Web applications and documents. The CD-ROM contains some carefully selected development tools including ActiveX Control Pad, HTML Layout Control, and ActiveX Control Lister for HTML.

VB.NET Language Pocket Reference

Author: Steven Roman, PhD,Ron Petrusha,Paul Lomax

Publisher: "O'Reilly Media, Inc."

ISBN: 0596529104

Category: Computers

Page: 152

View: 5046

Visual Basic .NET is a radically new version of Microsoft Visual Basic, the world's most widely used rapid application development (RAD) package. Whether you are just beginning application development with Visual Basic .NET or are already deep in code, you will appreciate just how easy and valuable the VB.NET Language Pocket Reference is.VB.NET Language Pocket Reference contains a concise description of all language elements by category. These include language elements implemented by the Visual Basic compiler, as well as all procedures and functions implemented in the Microsoft.VisualBasic namespace. Use it anytime you want to look up those pesky details of Visual Basic syntax or usage. With concise detail and no fluff, you'll want to take this book everywhere.

Programming Excel with VBA and .NET

Solve Real-World Problems with Excel

Author: Jeff Webb,Steve Saunders

Publisher: "O'Reilly Media, Inc."

ISBN: 9781449379056

Category: Computers

Page: 1116

View: 2366

Why program Excel? For solving complex calculations and presenting results, Excel is amazingly complete with every imaginable feature already in place. But programming Excel isn't about adding new features as much as it's about combining existing features to solve particular problems. With a few modifications, you can transform Excel into a task-specific piece of software that will quickly and precisely serve your needs. In other words, Excel is an ideal platform for probably millions of small spreadsheet-based software solutions. The best part is, you can program Excel with no additional tools. A variant of the Visual Basic programming language, VB for Applications (VBA) is built into Excel to facilitate its use as a platform. With VBA, you can create macros and templates, manipulate user interface features such as menus and toolbars, and work with custom user forms or dialog boxes. VBA is relatively easy to use, but if you've never programmed before, Programming Excel with VBA and .NET is a great way to learn a lot very quickly. If you're an experienced Excel user or a Visual Basic programmer, you'll pick up a lot of valuable new tricks. Developers looking forward to .NET development will also find discussion of how the Excel object model works with .NET tools, including Visual Studio Tools for Office (VSTO). This book teaches you how to use Excel VBA by explaining concepts clearly and concisely in plain English, and provides plenty of downloadable samples so you can learn by doing. You'll be exposed to a wide range of tasks most commonly performed with Excel, arranged into chapters according to subject, with those subjects corresponding to one or more Excel objects. With both the samples and important reference information for each object included right in the chapters, instead of tucked away in separate sections, Programming Excel with VBA and .NET covers the entire Excel object library. For those just starting out, it also lays down the basic rules common to all programming languages. With this single-source reference and how-to guide, you'll learn to use the complete range of Excel programming tasks to solve problems, no matter what you're experience level.

Visual Basic for Applications

Author: Diane Zak

Publisher: Course Technology Ptr

ISBN: 9780619000202

Category: Computers

Page: 984

View: 9628

This title teaches how to program in VBA by showing users how to manipulate objects in each Office application.Visual Basic for Applications offers a concept lesson, followed by lessons in Word, Access, and Excel, with PowerPoint covered in the end of chapter exercises. This title stresses the commonality of VBA in all the Office applications.

Microsoft Outlook Programming

Jumpstart for Administrators, Developers, and Power Users

Author: Sue Mosher

Publisher: Elsevier

ISBN: 0080491871

Category: Computers

Page: 619

View: 7248

Microsoft Outlook Programming unleashes the power of Microsoft Outlook, allowing administrators and end users to customize Outlook in the same way that they've used macros and templates to customize other programs like Excel and Word. Experienced developers will find the quick-start information they need to begin integrating Outlook into their applications. Microsoft Exchange administrators will get help automating common tasks such as announcing public folders and importing data to custom forms. Microsoft Outlook is the most widely used email program, and it offers the most programmability. This book introduces key concepts for programming both Outlook forms for storing and exchanging data and Visual Basic for Applications modules that add new features to Outlook. Central to this new edition, which covers both Outlook 2000 and Outlook 2002, is awareness of tighter security in Outlook. Designed to prevent transmission of computer viruses, the security restrictions can also get in the way of legitimate programs, but this book offers workarounds within the reach of novice programmers. It also covers many of the new features of Outlook 2002, such as the integrated Outlook View Control and searching across multiple folders using SQL syntax and the Search object. · Building block procedures for the most common Outlook programming tasks · Jargon-free language and practical examples to make the material more accessible to new Outlook programmers · Coverage of Outlook Email Security Update · Coverage of the Office XP Web Services Toolkit

VBScript Pocket Reference

Author: Paul Lomax,Matt Childs,Ron Petrusha

Publisher: "O'Reilly Media, Inc."

ISBN: 144935680X

Category: Computers

Page: 120

View: 7187

Microsoft's Visual Basic Scripting Edition (VBScript), a subset of Visual Basic for Applications, is a powerful language for Internet application development, where it can serve as a scripting language for server-side, client-side, and system scripting. Whether you're developing code for Active Server Pages, client-side scripts for Internet Explorer, code for Outlook forms, or scripts for Windows Script Host, VBScript Pocket Reference will be your constant companion.Don't let the pocket-friendly format fool you. Based on the bestsellingVBScript in a Nutshell, this small book details every VBScript language element--every statement, function, and object--both in VBScript itself, and in the Microsoft Scripting Runtime Library. There's a special emphasis on the following details: The syntax, using standard code conventions The arguments accepted by the function or procedure, if any exist Entries are arranged alphabetically by topic, so that you can, for instance, easily find details about that string-handling function that you can't quite remember. In addition, appendixes list VBScript operators and VBScript intrinsic constants.Regardless of how much VBScript programming experience you have, theVBScript Pocket Reference is the book you'll pick up time and time again as your standard quick reference guide to the VBScript language. It is indispensable for anyone writing scripts with VBScript.

Access Database Design & Programming

Creating Programmable Database Applications with Access 97, 2000, 2002 & 2003

Author: Steven Roman, PhD

Publisher: "O'Reilly Media, Inc."

ISBN: 1449366430

Category: Computers

Page: 450

View: 7370

Access Database Design & Programming takes you behind the details of the Access interface, focusing on the general knowledge necessary for Access power users or developers to create effective database applications. When using software products with graphical interfaces, we frequently focus so much on the interface that we forget about the general concepts that allow us to understand and use the software effectively. In particular, this book focuses on three areas: Database design. The book provides an enjoyable, informative overview of database design that carefully shows you how to normalize tables to eliminate redundancy without losing data. Queries. The book examines multi-table queries (i.e.,various types of joins) and shows how to implement them indirectly by using the Access interface or directly by using Access SQL. Programming. The book examines the VBA integrated development environment (IDE). It then goes on to provide an excellent introduction to Data Access Objects (DAO), ActiveX Data Objects (ADO), and ADO Extensions for Data Definition and Security (ADOX). These sections serve as a handy introduction and primer for basic database operations,such as modifying a table under program control, dynamically adding and deleting a record, and repositioning a record pointer. The concluding chapter focuses on common programming problems, such as computing running sums and comparing two sets. Unlike other Access books that take the long, detailed approach to every topic of concern to Access programmers, Access Database Design &Programming instead focuses on the core concepts, enabling programmers to develop solid, effective database applications. This book also serves as a 'second course' in Access that provides a relatively experienced Access user who is new to programming with the frequently overlooked techniques necessary to develop successfully in the Microsoft Access environment.Anyone interested in learning Access in depth, rather than just scraping the surface, will enjoy and benefit immensely from reading this book.

Mastering VBA for Office 2010

Author: Richard Mansfield

Publisher: John Wiley & Sons

ISBN: 9780470922637

Category: Computers

Page: 912

View: 6403

A comprehensive guide to the language used to customize Microsoft Office Visual Basic for Applications (VBA) is the language used for writing macros, automating Office applications, and creating custom applications in Word, Excel, PowerPoint, Outlook, and Access. This complete guide shows both IT professionals and novice developers how to master VBA in order to customize the entire Office suite for specific business needs. Office 2010 is the leading productivity suite, and the VBA language enables customizations of all the Office programs; this complete guide gives both novice and experienced programmers the knowledge they need to make maximum use of VBA for Office Supported with real-world examples in Word, Excel, PowerPoint, Outlook, and Access, this book offers clear, systematic tutorials with both intermediate and advanced content Covers learning how to work with VBA; recording macros; using loops and functions; using message boxes, input boxes, and dialog boxes; creating effective code; XML-based files; ActiveX; the developer tab; content controls; add-ins; embedded macros; and security Mastering VBA for Office 2010 prepares developers to customize all Microsoft Office 2010 applications for the unique needs of their employers.

Writing Word Macros

Author: Steven Roman

Publisher: "O'Reilly Media, Inc."

ISBN: 9781565927254

Category: Computers

Page: 388

View: 9326

Illustrates how to take advantage of using VBA in Word, with a no-nonsense introduction to Word Macros and VBA programming for power users and aspiring beginners.

Writing Excel Macros with VBA

Author: Steven Roman,Steven PhD

Publisher: "O'Reilly Media, Inc."

ISBN: 0596003595

Category: Computers

Page: 549

View: 2142

Offering a solid introduction to writing VBA macros and programs in Excel, this guide shows readers how to get more power out of Excel at the programming level.

Access VBA Programming

Author: Charles Brown,Ron Petrusha

Publisher: McGraw Hill Professional

ISBN: 9780072231977

Category: Computers

Page: 441

View: 1120

Take a look at this great application of VBA and learn to expand the capabilities of Access with simple programming. Author Charles E. Brown shows you step-by-step how to create your own code, work with Object-Oriented Programming, and more. Plus, discover and utilize key programming concepts that can be applied beyond VBA.

R in a Nutshell

A Desktop Quick Reference

Author: Joseph Adler

Publisher: "O'Reilly Media, Inc."

ISBN: 1449358225

Category: Computers

Page: 724

View: 7389

If you’re considering R for statistical computing and data visualization, this book provides a quick and practical guide to just about everything you can do with the open source R language and software environment. You’ll learn how to write R functions and use R packages to help you prepare, visualize, and analyze data. Author Joseph Adler illustrates each process with a wealth of examples from medicine, business, and sports. Updated for R 2.14 and 2.15, this second edition includes new and expanded chapters on R performance, the ggplot2 data visualization package, and parallel R computing with Hadoop. Get started quickly with an R tutorial and hundreds of examples Explore R syntax, objects, and other language details Find thousands of user-contributed R packages online, including Bioconductor Learn how to use R to prepare data for analysis Visualize your data with R’s graphics, lattice, and ggplot2 packages Use R to calculate statistical fests, fit models, and compute probability distributions Speed up intensive computations by writing parallel R programs for Hadoop Get a complete desktop reference to R

Excel Scientific and Engineering Cookbook

Adding Excel to Your Analysis Arsenal

Author: David M Bourg

Publisher: "O'Reilly Media, Inc."

ISBN: 9780596553173

Category: Computers

Page: 446

View: 1364

Given the improved analytical capabilities of Excel, scientists and engineers everywhere are using it--instead of FORTRAN--to solve problems. And why not? Excel is installed on millions of computers, features a rich set of built-in analyses tools, and includes an integrated Visual Basic for Applications (VBA) programming language. No wonder it's today's computing tool of choice. Chances are you already use Excel to perform some fairly routine calculations. Now the Excel Scientific and Engineering Cookbook shows you how to leverage Excel to perform more complex calculations, too, calculations that once fell in the domain of specialized tools. It does so by putting a smorgasbord of data analysis techniques right at your fingertips. The book shows how to perform these useful tasks and others: Use Excel and VBA in general Import data from a variety of sources Analyze data Perform calculations Visualize the results for interpretation and presentation Use Excel to solve specific science and engineering problems Wherever possible, the Excel Scientific and Engineering Cookbook draws on real-world examples from a range of scientific disciplines such as biology, chemistry, and physics. This way, you'll be better prepared to solve the problems you face in your everyday scientific or engineering tasks. High on practicality and low on theory, this quick, look-up reference provides instant solutions, or "recipes," to problems both basic and advanced. And like other books in O'Reilly's popular Cookbook format, each recipe also includes a discussion on how and why it works. As a result, you can take comfort in knowing that complete, practical answers are a mere page-flip away.

VBA Developer's Handbook

Author: Ken Getz,Mike Gilbert

Publisher: John Wiley & Sons

ISBN: 9780782153330

Category: Computers

Page: 1104

View: 4094

WRITE BULLETPROOF VBA CODE FOR ANY SITUATION This book is the essential resource for developers working with any of the more than 300 products that employ the Visual Basic for Applications programming language. Written by recognized VBA experts, it provides detailed coverage of a wide range of specific VBA programming challenges. Its careful, step-by-step instructions and thousands of lines of code offer answers, while teaching you to devise new and creative solutions. The instruction applies equally to all VBA environments, whether you are building standalone applications or customizing commercial products using their built-in VBA programmability. Coverage Includes Manipulating text, numbers, and dates Using automation to control other applications Creating objects using VBA class modules Using standard search and sort algorithms from within VBA Creating standard dynamic data structures, including linked lists, binary trees, stacks, and queues Working with Windows system information, including memory status, screen info, mouse, keyboard, and power status Working with Windows Registry data Retrieving and setting Windows networking information Working with the Windows file system, iterating through folders, creating and deleting files Adding sound and movies to VBA apps using Windows multimedia extensions Tapping the system capabilities provided by the Windows Scripting Runtime library Writing add-ins for the Visual Basic environment Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

VBA Developer's Handbook

Author: Ken Getz,Mike Gilbert

Publisher: Sybex

ISBN: 9780782129786

Category: Computers

Page: 1104

View: 3235

WRITE BULLETPROOF VBA CODE FOR ANY SITUATION This book is the essential resource for developers working with any of the more than 300 products that employ the Visual Basic for Applications programming language. Written by recognized VBA experts, it provides detailed coverage of a wide range of specific VBA programming challenges. Its careful, step-by-step instructions and thousands of lines of code offer answers, while teaching you to devise new and creative solutions. The instruction applies equally to all VBA environments, whether you are building standalone applications or customizing commercial products using their built-in VBA programmability. Coverage Includes Manipulating text, numbers, and dates Using automation to control other applications Creating objects using VBA class modules Using standard search and sort algorithms from within VBA Creating standard dynamic data structures, including linked lists, binary trees, stacks, and queues Working with Windows system information, including memory status, screen info, mouse, keyboard, and power status Working with Windows Registry data Retrieving and setting Windows networking information Working with the Windows file system, iterating through folders, creating and deleting files Adding sound and movies to VBA apps using Windows multimedia extensions Tapping the system capabilities provided by the Windows Scripting Runtime library Writing add-ins for the Visual Basic environment Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.