Excel VBA Macro Programming (häftad)
Fler böcker inom
Format
Häftad (Paperback)
Språk
Engelska
Antal sidor
320
Upplaga
illustrated ed
Förlag
McGraw-Hill Education
Illustrationer
90ill.
Dimensioner
240 x 190 x 30 mm
Vikt
560 g
Antal komponenter
1
ISBN
9780072231441
Excel VBA Macro Programming (häftad)

Excel VBA Macro Programming

Häftad Engelska
349
Skickas inom 5-8 vardagar.
Fri frakt inom Sverige för privatpersoner.
Finns även som
Visa alla 1 format & utgåvor
Publisher's Note: 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.
  • 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


Visa hela texten

Passar bra ihop

  1. Excel VBA Macro Programming
  2. +
  3. Microsoft Access 2010 VBA Macro Programming

De som köpt den här boken har ofta också köpt Microsoft Access 2010 VBA Macro Programming av Richard Shepherd (häftad).

Köp båda 2 för 688 kr

Kundrecensioner

Har du läst boken? Sätt ditt betyg »

Bloggat om Excel VBA Macro Programming

Övrig information

McGraw-Hill authors represent the leading experts in their fields and are dedicated to improving the lives, careers, and interests of readers worldwide

Innehållsförteckning

Part I: Programming in Excel VBA

1: The Basics

2: Variables, Arrays, Constants, and Data Types

3: Modules, Functions, and Subroutines

4: Programming Basics: Decisions and Looping

5: Strings and Functions and Message Boxes

6: Operators

7: Debugging

8: Errors and the Error Function

9: Dialogs

10: Common Dialog Control

11: Command Bars and Buttons

Part II: Object Models

12: The Excel Object Model

13: The Excel Object Model-Main Objects

14: Using Excel to Interact with Other Office Programs

Part III: Advanced Techniques in Excel VBA

15: Charts and Graphs

16: Working with Databases

17: API Calls

18: Class Modules

19: Animation

Part IV: VBA in Action

20: Converting Labels to Numbers and Numbers to Labels

21: Transposing a Range of Cells

22: Adding Formula Details into Comments

23: Calculating a Range

24: Reversing a Label

25: Who Created the Workbook?

26: Evaluating a Cell

27: Sorting Worksheets into Alphabetical Order

28: Replacing Characters in a String

29: Timed Events

30: Auto Totaling a Matrix of Numbers

31: Absolute and Relative Formulas

32: Coloring Alternate Rows and Columns of the Spreadsheet

33: Coloring Cells Containing Formulas

34: Summing Cells by Reference to a Master Cell

35: Globally Changing a Range of Values

36: Displaying Hidden Sheets Without a Password

37: Searching Multiple Sheets and Workbooks

38: Brighten Up Your Comments

39: An Alternative to Message Boxes

40: Working with Shapes

41: Turning Your VBA Code into an Add-In

A: ASCII Character Codes