|
Showing 1 - 10 of
10 matches in All Departments
Updated for Excel 2021 and based on the bestselling editions from
previous versions, Excel 2021 / Microsoft 365 Programming by
Example is a practical, how-to book on Excel programming, suitable
for readers already proficient with the Excel user interface. If
you are looking to automate Excel routine tasks, this book will
progressively introduce you to programming concepts via numerous
illustrated hands-on exercises. More advanced topics are
demonstrated via custom projects. From recording and editing a
macro and writing VBA code from scratch to programming the Ribbon
interface and working with XML documents, this book takes you on a
programming journey that will change the way you work with Excel.
The book provides information on performing automatic operations on
files, folders, and other Microsoft Office applications. It also
covers proper use of event procedures, testing and debugging, and
guides you through programming more advanced Excel features, such
as working with VBA classes and raising your own events in
standalone class modules. Includes companion files with source
code, hands-on projects, and figures.
This book is suitable for readers already familiar with the Excel
user interface and introduces programming concepts via numerous
multi-step, practical exercises. More advanced topics are
introduced via custom projects. Covers recording and editing a
macro and writing VBA code through working with XML documents and
using ASP to display data on the Web. Microsoft Excel 2013
Programming by Example with VBA, XML and ASP is a practical how-to
book on Excel programming, suitable for readers already familiar
with the Excel user interface. The book introduces programming
concepts via numerous multi-step, illustrated, hands-on exercises.
More advanced topics are introduced via custom projects. From
recording and editing a macro and writing VBA code to working with
XML documents and using classic ASP to access and display data on
the Web, this book takes you on a programming journey that will
change the way you work with Excel. Completely updated for Excel
2010, this book provides information on performing automatic
operations on files, folders, and other Microsoft Office
applications. It also covers proper use of event procedures,
testing and debugging, and programming advanced Excel features such
as PivotTables, PivotCharts, and SmartTags. The chapters are loaded
with illustrated hands-on projects and exercises that tell you
exactly where to enter code, how to debug it, and then run it. Each
exercise/project step is clearly explained as it is performed.
Features: Explores in great detail the latest version of Excel and
all of its features. Covers recording and editing a macro and
writing VBA code through working with XL documents and using ASP to
display data on the Web. Covers Office Web Apps.
Updated for Access 2016 and based on the bestselling editions from
previous versions, Microsoft Access 2016 Programming by Example
with VBA, XML and ASP is a practical how-to book on Access
programming, suitable for readers already proficient with the
Access user interface (UI). If you are looking to automate Access
routine tasks, this book will progressively introduce you to
programming concepts via numerous illustrated hands-on exercises.
More advanced topics are demonstrated via custom projects. Includes
a comprehensive disc with source code, supplemental files, and
color screen captures (Also available from the publisher for
download by writing to [email protected]). With concise and
straightforward explanations, you learn how to write and test your
programming code with the built-in Visual Basic Editor; understand
and use common VBA programming structures such as conditions,
loops, arrays, and collections; code a ""message box""; reprogram
characteristics of a database; and use various techniques to query
and manipulate your Access .mdb and .accdb databases. The book
shows you how you can build database solutions with Data Access
Objects (DAO) and ActiveX Data Objects (ADO); define database
objects and manage database security with SQL; enhance and alter
the way users interact with database applications with Ribbon
customizations and event programming in forms and reports. You also
learn how to program Microsoft Access databases for Internet access
with Active Server Pages (Classic ASP), HTML, and XML. Features:
Contains over thirty chapters loaded with illustrated hands-on
exercises and projects that guide you through the VBA programming
language. Each example tells you exactly where to enter code and
how to test it and then run it. Includes a comprehensive disc with
source code, supplemental files, and color screen captures (Also
available from the publisher for download by writing to
[email protected]). Explains how to store data for further
manipulation in variables, arrays, and collections while teaching
you to write both simple and complex VBA programming routines and
functions. Teaches you how to programmatically create and access
database tables and fields. Shows you how to insert, update, and
delete data via programming code using various data access
techniques. Gets you proficient creating and running simple and
parameterized queries against your Access databases. Gets you
comfortable using external data sources with Access (Excel, Word,
flat files, XML, and SQL Server). Teaches you how to take control
of your forms and reports by writing programming code known as
event procedures. Shows you how to use various types of macros and
templates. Takes your programming skills to the Web by introducing
you to dynamic XML and Classic ASP pages. On the disc: (Also
available from the publisher for download by writing to
[email protected]). All source code and supplemental files for
the Hands-On exercises and custom projects All images from the text
(including 4-color screenshots)
Updated for Excel 2016 and based on the bestselling editions from
previous versions, Microsoft Excel 2016 Programming by Example with
VBA, XML and ASP is a practical, how-to book on Excel programming,
suitable for readers already proficient with the Excel user
interface (UI). If you are looking to automate Excel routine tasks,
this book will progressively introduce you to programming concepts
via numerous, illustrated, hands-on exercises. Includes a
comprehensive disc with source code, supplemental files, and color
screen captures (Also available from the publisher for download by
writing to [email protected]). More advanced topics are
demonstrated via custom projects. From recording and editing a
macro and writing VBA code to working with XML documents and using
Classic ASP pages to access and display data on the Web, this book
takes you on a programming journey that will change the way you
work with Excel. The book provides information on performing
automatic operations on files, folders, and other Microsoft Office
applications. It also covers proper use of event procedures,
testing and debugging, and guides you through programming advanced
Excel features such as PivotTables, PivotCharts, and the Ribbon
interface. Features: Contains 28 chapters loaded with illustrated
""Hands-On"" exercises and projects that guide you through the VBA
programming language. Each example tells you exactly where to enter
code, how to test it and then run it. Includes a comprehensive disc
with source code, supplemental files, and color screen captures
(Also available from the publisher for download by writing to
[email protected]). Takes you from introductory
topics--including recording and editing macros, using variables,
and constants, writing subroutines/functions, conditional
statements, and various methods of coding loops to repeat
actions--to intermediate and advanced topics that include working
with collections, class modules, arrays, file and database access,
custom forms, error handling and debugging. Includes comprehensive
coverage of native file handling in VBA, Windows Scripting Host
(WSH), and low-level File Access. Demonstrates how to interact with
Microsoft Access databases using both ADO and DAO Object Libraries
to access and manipulate data. Includes chapters on programming
charts, PivotTables, dialog boxes, custom forms, the Ribbon,
Backstage View, context/shortcut menu customizations, as well as
proper use of event procedures and callbacks. Provides a quick
Hands-On introduction to the data analysis and transformation
process using the new Excel 2016 Get & Transform feature and
the ""M"" language formulas. Provides a practical coverage of using
Web queries, HTML, XML, and VBScript in Classic ASP to retrieve and
publish Excel data to the Web. On The Companion Files: All source
code and supplemental files for the Hands-On exercises and custom
projects All images from the text (including 4-color screenshots)
In this completely updated edition covering Excel 2016 and previous
versions, Microsoft Excel Functions & Formulas 4/e demonstrates
the secrets of Excel through the use of practical and useful
examples in a quick reference format. Easy to use and equipped with
a variety of functions, Microsoft Excel is the tool of choice when
it comes to crunching numbers, building charts, and analyzing
tables. With over 250 Excel worksheet examples, files, and added
video tutorials, the book is an excellent resource for all Excel
users who want to understand, create, and apply formulas.
Experienced users will also find Microsoft Excel Functions &
Formulas 4/2 an excellent reference for many of the program's
advanced formulas and functions. The text is easy to understand
with numerous step-by-step instructions and the actual, ready to
use, Excel screenshots of the input and output from the formulas. A
CD-ROM accompanies the book with video tutorials, worksheet files
of examples for numerous functions, formulas, and all the figures
from the text.
Excel 2007 VBA Programming with XML and ASP offers a hands-on
approach for those looking to extend and customize Excel
functionality. From recording a simple macro and writing VBA code
to working with XML documents and using ASP to access and display
data, this book takes you on a programming journey that will change
the way you work with Excel Learn how to: * Automate spreadsheet
tasks with macros. * Write VBA code to program PivotTables,
generate charts, build dialog boxes, and customize the Ribbon. *
Handle errors and debug programs. * Create hyperlinks and publish
HTML files. * Retrieve data from the web directly into Excel. *
Develop and manipulate smart tags using XML.
With more than 275 applied examples and 10 projects, Access users
can quickly build database solutions with ActiveX Data Objects
(ADO), perform database tasks with Jet/Access Structured Query
Language (SQL) and export/import Access data to and from XML both
manually and programmatically. The book, which covers the latest
release of Access and earlier versions, is divided into five parts:
an introduction to VBA programming, manipulating databases with
ADO, using DDL, event programming, and using ASP and XML. The text
will show you how to write and debug your programming code with the
Visual Basic Editor; understand and use common VBA programming
structures such as conditions, loops, arrays, and collections; code
a ""message box"" and reprogram characteristics of a database;
query and manipulate your database from a Web browser with Active
Server Pages (ASP) and many more practical techniques. Features:
Covers in great detail the latest version of Access and all of its
features. Includes more than 275 applied examples and 10 projects.
Covers Office Web Apps
Microsoft Excel 2010 Programming by Example with VBA, XML and ASP
is a practical how-to book on Excel programming, suitable for
readers already familiar with the Excel user interface. The book
introduces programming concepts via numerous multi-step,
illustrated, hands-on exercises. More advanced topics are
introduced via custom projects. From recording and editing a macro
and writing VBA code to working with XML documents and using
classic ASP to access and display data on the Web, this book takes
you on a programming journey that will change the way you work with
Excel. Completely updated for Excel 2010, this book provides
information on performing automatic operations on files, folders,
and other Microsoft Office applications. It also covers proper use
of event procedures, testing and debugging, and programming
advanced Excel features such as PivotTables, PivotCharts, and
SmartTags. Thirty chapters loaded with illustrated hands-on
projects and exercises that tell you exactly where to enter code,
how to debug it, and then run it. Each exercise/project step is
clearly explained as it is performed.Table of Contents1. Automating
Worksheet Tasks with Macros. 2. Exploring the Visual Basic Editor
(VBE). 3. Excel VBA Fundamentals. 4. Using Variables, Data Types,
and Constants. 5. VBA Procedures: Subroutines and Functions.6.
Decision Making with VBA. 7. Repeating Actions in VBA. 8.Working
with Arrays. 9. Working with Collections and Class Modules. 10. VBE
Tools for Testing and Debugging. 11. Conditional Compilation and
Error Trapping. 12. File and Folder Manipulation with VBA. 13. File
and Folder Manipulation with Windows Script Host (WSH). 14. Using
Low-Level File Access. 15. Using Excel VBA to Interact with Other
Applications. 16. Using Excel with Microsoft Access. 17.
Event-Driven Programming. 18. Using Dialog Boxes. 19. Creating
Custom Forms. 20. Formatting Worksheets with VBA. 21. Context Menu
Programming and Ribbon Customizations. 22. Printing and Sending
E-mail from Excel. 23. Programming PivotTables and PivotCharts. 24.
Using and Programming Excel Tables. 25. Programming Special
Features. 26. Programming the Visual Basic Editor (VBE). 27. HTML
Programming and Web Queries. 28. Excel and Active Server Pages. 29.
Using XML in Excel 2010. 30. Calling Windows API Functions from
VBA. Index.
As part of the Pocket Primer series, this book was designed for
someone like you who needs to master Access programming
fundamentals without spending too much time. All you need is a
short book to get you started. It will show you only the things you
need to know to feel at home with VBA. What you learn in this book
on Access programming will also apply to, say, Excel programming.
The book is divided into nine chapters that progressively introduce
you to programming Microsoft Access 2016. Features: Includes a
companion disc with all of the hands-on files needed to complete
the chapter projects and all the images from the text Introduces
you to programming Microsoft Access 2016
|
You may like...
The High Notes
Danielle Steel
Paperback
R340
R266
Discovery Miles 2 660
Loot
Nadine Gordimer
Paperback
(2)
R398
R330
Discovery Miles 3 300
|