| |||||||||||||||
 Trade In this Item for up to £0.80
Trade in Excel VBA Macro Programming for an Amazon.co.uk gift card of up to £0.80, which you can then spend on millions of items across the site. Plus, get an extra £5 when you trade in books worth £10 or more until June 30, 2012. Trade-in values may vary (terms apply). Find more products eligible for trade-in.
|
|
There is a newer edition of this item:
|
Frequently Bought Together
Product details
|
More About the Author
Product Description
Product Description
From the Back Cover
- 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
This chapter is intended to take you through the basic steps of using the Visual Basic Editor window and writing a simple piece of VBA code. Read the first page
Concordance
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Tags Customers Associate with This Product(What's this?)Click on a tag to find related items, discussions, and people.
|
What Other Items Do Customers Buy After Viewing This Item?
Customer Reviews
I work in accountancy so I use Excel spreadsheets very frequently. However, I had only been able to record macros and did not have any understanding of how they worked. This book has taken me from the very basics through to some very complicated code and creating a professional add in file. I found everything was well explained and plenty of working examples were used. It shows how to build GUI interfaces which look really professional.
It describes the Excel Object model in very good detail - I have now realised that the object model is at the heart of the code and you need a very good understanding of this in order to start writing code for Excel. Two chapters are devoted to this.
There are a huge number of tricks explained in this book some of which could be described as hacks. I found out how to copy and view a hidden worksheet which was password protected simply using commands in the object model.
This has certainly whetted my appetite for Excel VBA
There are also 21 example projects which start off simply and then work through to more complicated listings, some of which cover several pages of code and include construction of GUI interfaces. All the code is thoroughly explained and is easy to follow through. Several cool topics are included here - I loved the one on how to change shapes of comment boxes.
The final chapter draws all these projects into a professional Excel Addin which sounds complicated, but I managed it. I really felt that I had achieved something when I produced my XLA file and it worked like any other addin! It even set its own menu item up in the Excel menu.
The author hits the nail on the head in the introduction when he mentions learning by example and experimentation. You can read a book on a topic, but you will not learn it unless you put it into action, and this book gives plenty of opportunity to do that.
Great information on data manipulation. Chapter 16 gives you all you need to link to an Access database and pull the data across into Excel. Once you have the data in Excel, half a dozen chapters give fully worked examples to show you how to manipulate this data from inside your macro using code you can understand. Take a look on the Amazon 'See Inside feature' on this book.
One of the most interesting topics was creating Excel Add Ins. This is effectively a standalone file that you can give to anyone so that they can use your code and ideas in Excel. You can even adapt the Excel menu structure when your add in loads for a really professional appearance.
If you use Excel a lot macro automation is the key to working efficiently. This book is the best I have seen and the price is very competitive too.
end of review, end of review, end of review, end of review
The contents of the book in no way match these ratings
Layout is very poor, examples weak and... Read more
This book could change your life, the power of VBA and Macros to excel is... Read more
Listmania!
Look for similar items by category
- Books > Computing & Internet > Digital Lifestyle > Online Shopping > Amazon
- Books > Computing & Internet > Microsoft Windows > Applications > Excel > Programming
- Books > Computing & Internet > Programming > Languages & Tools
- Books > Computing & Internet > Programming > Microsoft Windows > Excel
- Books > Computing & Internet > Software & Graphics > Business & Home Office > Spreadsheets
Look for similar items by subject
Feedback
- Would you like to update product info or give feedback on images?
- I am the Author, and I want to comment on my book.
- I am the Publisher, and I want to comment on this book.
|
