Average Reviews:
(More customer reviews)This book has opened up a whole new area of Excel for me. I can now do anything in VBA code within an Excel spreadsheet! My friends at work have become impressed with my Excel code. Recently, my boss was given a spreadsheet with similar information on 50 sheets within one file and he wanted to see it all on one sheet going downwards. Within 15 minutes I was able to produce VBA code to do this transition - he was over the moon!
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
Click Here to see more reviews about: Excel VBA Macro Programming
Make Excel work harder and faster for you. This unique book presents sample code for more than twenty practical, high-powered Excel VBA macro applications. You'll get all the essentials of VBA, and then explore ways to power Excel with VBA. Automate tasks, convert numbers to labels, transpose cells, add formula details, globally changes values, and much, much more.
Get 35% OFF
Click here for more information about Excel VBA Macro Programming
0 comments:
Post a Comment