Microsoft Office Excel 2007 Programming: Your Visual Blueprint for Creating Interactive Spreadsheets

( 2 )

Overview

Microsoft® Office Excel® 2007 Programming

Welcome to the only guidebook series that takes a visual approach to professional-level computer topics. Open the book and ...

See more details below
Paperback
$23.15
BN.com price
(Save 14%)$26.99 List Price
Other sellers (Paperback)
  • All (16) from $3.99   
  • New (10) from $4.40   
  • Used (6) from $3.99   
Sending request ...

Overview

Microsoft® Office Excel® 2007 Programming

Welcome to the only guidebook series that takes a visual approach to professional-level computer topics. Open the book and you'll discover step-by-step screen shots that demonstrate over 140 key Excel programming techniques, including:

  • Assigning digital signatures to macros
  • Setting properties for a project
  • Assigning values to a variable
  • Changing the properties of an object
  • Formatting a numeric expression
  • Processing a runtime error
  • Saving worksheets to another file
  • Displaying a built-in dialog box
  • Creating custom Ribbon tabs
  • Building and debugging add-ins

Extra Apply It 

  • "Apply It" and "Extra" sidebars highlight useful tips
  • High-resolution screen shots demonstrate each task
  • Succinct explanations walk you through step by step
  • Two-page lessons break big topics into bite-sized modules
Read More Show Less

Product Details

  • ISBN-13: 9780470132302
  • Publisher: Wiley, John & Sons, Incorporated
  • Publication date: 9/11/2007
  • Series: Visual Blueprint Series , #6
  • Edition number: 1
  • Pages: 352
  • Product dimensions: 7.40 (w) x 9.20 (h) x 0.85 (d)

Meet the Author

Denise Etheridge is a certified public accountant as well as the president and founder of Baycon Group, Inc. She publishes Web sites, provides consulting services on accounting-related software, and authors computer-related books. You can visit www.baycongroup.com to view her online tutorials.
Read More Show Less

Table of Contents

HOW TO USE THIS BOOK.

1 USING MACROS AND FORM CONTROLS.

Introducing Excel Programming.

Introducing Macros.

Set Macro Security.

Create a Digital Signature.

Record a Macro.

Assign a Digital Signature to a Macro.

Run a Macro.

Create and Launch a Keyboard Shortcut.

Assign a Macro to the Quick Access Toolbar.

Delete a Macro.

Add a Form Control to a Worksheet.

Assign Values to a Form Control.

Add a Macro to a Form Control.

2 USING THE VISUAL BASIC EDITOR.

Introducing the Visual Basic Editor.

Activate the Visual Basic Editor.

Open Visual Basic Editor Windows.

Set Properties for a Project.

Set Display Options for the Code Window.

Add a New Module.

Remove a Module.

Hide a Macro.

Update a Macro.

3 INTRODUCING VISUAL BASIC FOR APPLICATIONS.

Create Sub Procedures.

Create Functions.

Comment Your Code.

Understanding Variables and Data Types.

Reference Cells and Ranges.

Declare Variables.

Work with Numbers.

Work with Strings.

Create a Constant.

4 INTRODUCING THE EXCEL OBJECT MODEL.

Discover the Excel Object Model.

Access the Excel Object Model Reference.

Create an Object Variable.

Change the Properties of an Object.

Compare Object Variables.

Using an Object Method.

Display a Built-in Dialog Box.

5 UNDERSTANDING ARRAYS.

Declare an Array.

Declare a Multidimensional Array.

Convert a List to an Array.

Redimension an Array.

Create a User-Defined Data Type.

6 CONTROLLING PROGRAM FLOW.

Create Comparisons.

Make Use of Logical Operators.

Employ Do While Loops.

Create Do Until Loops.

Create For Next Loops.

Execute For Each In Loops.

Create If Then Else Statements.

Construct Select Case Statements.

GoTo a Named Location.

Call a Procedure.

7 USING EXCEL WORKSHEET FUNCTIONS.

Work with Excel Worksheet Functions.

Work with a MsgBox Function.

Using the InputBox Function.

Retrieve the Current Date and Time.

Perform Date and Time Calculations.

Format a Date Expression.

Format a Numeric Expression.

Change the Case of a String.

Return a Portion of a String.

8 DEBUGGING MACROS.

Debug a Procedure with Inserted Break Points.

Using the Watches Window to Debug a Procedure.

Step through a Procedure.

Use the Immediate Window.

Resume Execution When an Error Is Encountered.

Process a Run-Time Error.

9 WORKING WITH WORKBOOKS AND FILES.

Open a Workbook.

Open a Text File as a Workbook.

Open a File Requested by the User.

Save a Workbook.

Save a Workbook in a Format Specified by the User.

Determine if a Workbook Is Open.

Close a Workbook.

Create a New Workbook.

Delete a File.

10 WORKING WITH WORKSHEETS.

Add a Sheet.

Delete a Sheet.

Move a Sheet.

Copy and Paste a Sheet.

Hide a Sheet.

Change the Name of a Sheet.

Save a Sheet to Another File.

Protect a Worksheet.

Protect a Chart.

Print a Sheet.

Sort Worksheets by Name.

11 DEFINING RANGES.

Using the Range Property.

Using the Cells Property.

Combine Multiple Ranges.

Using the Offset Property.

Delete a Range of Cells.

Hide a Range of Cells.

Create a Range Name.

Resize a Range.

Insert a Range.

Set the Width of Columns in a Range.

Set the Height of Rows in a Range.

Convert a Column of Text into Multiple Columns.

Find the Intersection of Two Ranges.

12 WORKING WITH CELLS.

Cut and Paste Ranges of Cells.

Copy and Paste Ranges of Cells.

Using Paste Special Options When Pasting.

Add Comments to a Cell.

Automatically Fill a Range of Cells.

Copy a Range to Multiple Sheets.

Place a Border Around a Range of Cells.

Find Specific Cell Values.

Find and Replace Values in Cells.

13 CREATING DIALOG BOXES AND CUSTOMIZING THE RIBBON.

UserForm Basics.

Create a Custom Dialog Box.

Call a Custom Dialog Box from a Procedure.

Capture Input from a Custom Dialog Box.

Validate Input from a Dialog Box.

Create Custom UserForm Controls.

Create a UserForm Template.

Create a CustomUI.xml File.

Customize the Ribbon.

Add Additional Options to the Ribbon.

14 WORKING WITH CHARTS.

Create a Chart Sheet.

Embed a Chart in a Worksheet.

Apply Chart Wizard Settings to a Chart.

Add a New Data Series to a Chart.

Format Chart Text.

Create Charts with Multiple Chart Types.

Add a Data Table to the Chart.

Customize a Chart Axis.

15 AUTOMATING PROCEDURES WITH EXCEL EVENTS.

Understanding Excel Events.

Run a Procedure as a Workbook Opens.

Run a Procedure before Closing a Workbook.

Run a Procedure before Saving a Workbook.

Run a Procedure When Excel Creates a Workbook.

Execute a Procedure at a Specific Time.

Execute a Procedure When You Press Keys.

16 BUILDING ADD-INS.

Create an Add-In.

Set Add-in Properties.

Install Add-Ins.

Using VBA to Load Add-Ins.

17 UNDERSTANDING.

Introducing XML.

Understanding Excel XML Files.

Open an XML File in Excel as a Table.

Create an XML Map.

Import and Export XML Files Using Excel.

Load XML Files Using VBA.

Import XML Files Using VBA.

APPENDIX A: VBA QUICK REFERENCE.

APPENDIX B: RIBBON CONTROLS QUICK REFERENCE.

INDEX.

Read More Show Less

Customer Reviews

Average Rating 4
( 2 )
Rating Distribution

5 Star

(0)

4 Star

(2)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing all of 2 Customer Reviews
  • Anonymous

    Posted October 5, 2007

    VB programming inside Excel

    Excel is really Visual Basic with a powerful, though specialised, user interface. Where the latter is a spreadsheet. Of course, if you are an Excel user, you likely think of it primarily as a spreadsheet. But the lessons in this book show that Excel can be very flexible, if you are willing to write simple VB programs. The lessons are formatted as 2 pages each. Brief. Examples include being able to access the file system, to delete files. But most of the examples naturally pertain to manipulating objects within a spreadsheet. Like changing properties of an object. Or creating it in the first place. The pedagogy also includes generous numbers of screen captures, for easier uptake. The only drawback is that the author's format (or rather this series' format) of explaining each lesson in 2 pages means that more advanced functionality is not described.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted July 23, 2009

    No text was provided for this review.

Sort by: Showing all of 2 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)