Wiley Excel Programming 978-0-470-59159-8 Manuale Utente
Codici prodotto
978-0-470-59159-8
2
1
2
4
2
3
Introducing Excel
Programming
Programming
A
s you probably know, Microsoft Excel is an
electronic worksheet you can use for a variety of
purposes, including the following: maintain lists;
electronic worksheet you can use for a variety of
purposes, including the following: maintain lists;
perform mathematical, financial, and statistical
calculations; create charts; analyze your data with
PivotTables; locate data; find trends in your data; and
present your data to others.
This book is about automating the tasks you perform in
Excel by using Visual Basic for Applications (VBA). You
can use VBA to automate those repetitive tasks you
perform frequently. For example, if the layout of your
monthly report rarely changes, you can use VBA to set up
your report each month.
VBA is a programming language; however, you do not
have to be a programmer to automate the tasks you
perform in Excel. You can also automate a task by using
the macro recorder to create a macro. A macro is a
calculations; create charts; analyze your data with
PivotTables; locate data; find trends in your data; and
present your data to others.
This book is about automating the tasks you perform in
Excel by using Visual Basic for Applications (VBA). You
can use VBA to automate those repetitive tasks you
perform frequently. For example, if the layout of your
monthly report rarely changes, you can use VBA to set up
your report each month.
VBA is a programming language; however, you do not
have to be a programmer to automate the tasks you
perform in Excel. You can also automate a task by using
the macro recorder to create a macro. A macro is a
recording of the steps you want to automate. You just
click a button to turn on the macro recorder and begin
performing the steps as you normally would. Excel records
each step and creates the VBA code. When you finish, you
click the Stop Record button. When you select your macro
in the Macro dialog box and then click the Run button,
Excel plays back the steps you recorded. For example, if
you record the steps necessary to set up your monthly
report, all you have to do each month thereafter is click a
button and Excel automatically sets up your report.
With VBA, you can do more than just create macros. You
can use VBA to edit macros, create new functions, create
custom applications, and create add-ins. For these tasks,
you must learn the VBA programming language. This
book teaches VBA. It is based on Office 2010. Code you
write for Office 2010 may not be compatible with earlier
versions of Excel.
click a button to turn on the macro recorder and begin
performing the steps as you normally would. Excel records
each step and creates the VBA code. When you finish, you
click the Stop Record button. When you select your macro
in the Macro dialog box and then click the Run button,
Excel plays back the steps you recorded. For example, if
you record the steps necessary to set up your monthly
report, all you have to do each month thereafter is click a
button and Excel automatically sets up your report.
With VBA, you can do more than just create macros. You
can use VBA to edit macros, create new functions, create
custom applications, and create add-ins. For these tasks,
you must learn the VBA programming language. This
book teaches VBA. It is based on Office 2010. Code you
write for Office 2010 may not be compatible with earlier
versions of Excel.
Introducing Excel Programming
1
Click the Developer tab.
Note: See the section “Introducing Macros” to learn how
to display the Developer tab.
to display the Developer tab.
Use the options in the Code group to automate
your tasks.
your tasks.
2
Click either of these Record Macro buttons to
record a macro.
record a macro.
Note: See the section “Record a Macro” for more details.
3
Click Macros to run a macro.
Note: See the section “Run a Macro” for more details.
•
Use the options in the Controls group to add
check boxes, fields, and other form controls
to your worksheet.
to your worksheet.
•
Use the options in the XML group to work
with XML.
4
Click Visual Basic or press Alt+F11.
Excel moves to the Visual Basic for
Applications Editor (VBE).
Applications Editor (VBE).
03_591598-ch01.indd 2
03_591598-ch01.indd 2
6/11/10 1:41 PM
6/11/10 1:41 PM
COPYRIGHTED MATERIAL