|
||||||||||||||||||||
|
||||||||||||||||||||
|
||||||||||||||||||||
Excel 2007 VBA Programmer's Reference
und über 1 Million weitere Bücher verfügbar für Amazon Kindle .
Erfahren Sie mehr
| ||||||||||||||||||
 Gutschein erhalten
Tauschen Sie jetzt Excel 2007 VBA Programmer's Reference (Programmer to Programmer) gegen einen Amazon-Gutschein in Höhe von EUR 5,35 ein - einlösbar für Tausende von Artikeln bei Amazon.de. Entdecken Sie mehr eintauschbare Bücher im Bücher Trade-In Shop. Bitte beachten Sie die Teilnahmebedingungen.
 Jetzt für Amazon Student anmelden und um 20% erhöhten Eintauschwert sichern. |
Wird oft zusammen gekauft
Produktinformation
Möchten Sie die Produktinformationen aktualisieren oder Feedback zu den Produktabbildungen geben?
Ist der Verkauf dieses Produkts für Sie nicht akzeptabel? |
Mehr über die Autoren
Entdecken Sie Bücher, lesen Sie über Autoren und mehr
Produktbeschreibungen
Kurzbeschreibung
Get ready to take your Excel applications to the next level by harnessing the power of the VBA language. This comprehensive resource will help you gain more control over your spreadsheets by using VBA while also showing you how to develop more dynamic Excel applications for other users. From introductory concepts to advanced developer topics, it guides you through every aspect of Excel 2007, including the Ribbon and the XML file formats.
In order to master all of the new features of this program, you'll find an introduction to VBA and details on how to use it to enhance Excel. You'll then learn how to work with the key objects and uncover the best ways to gain access to workbooks, worksheets, charts, and more. And you'll find out how to write code for international compatibility, program the Visual Basic Editor, and use the functions in the Win32 API, which will expand your Excel VBA programming skills.
What you will learn from this book
* How to write code that is readable, easy to maintain, and runs at maximum speed
*
Tips for utilizing the Visual Basic(r) Editor and its multitude of tools
*
Techniques for accessing data in a range of formats
*
Ways to set up your applications and convert them to add-ins
*
How to manipulate the Office XML file formats
*
A thorough explanation of RibbonX
*
Best practices for managing external data and using OLAP data sources
*
Methods for effectively debugging your application
*
Tips for packaging and distributing customized applications to other users
Who is this book for?
This book is for Excel users and programmers from beginning to advanced. You should have a reasonable working knowledge of Excel and a full installation of the software.
Wrox Programmer's References are designed to give the experienced developer straight facts on a new technology, without hype or unnecessary explanations. They deliver hard information with plenty of practical examples to help you apply new tools to your development projects today.
In order to master all of the new features of this program, you'll find an introduction to VBA and details on how to use it to enhance Excel. You'll then learn how to work with the key objects and uncover the best ways to gain access to workbooks, worksheets, charts, and more. And you'll find out how to write code for international compatibility, program the Visual Basic Editor, and use the functions in the Win32 API, which will expand your Excel VBA programming skills.
What you will learn from this book
* How to write code that is readable, easy to maintain, and runs at maximum speed
*
Tips for utilizing the Visual Basic(r) Editor and its multitude of tools
*
Techniques for accessing data in a range of formats
*
Ways to set up your applications and convert them to add-ins
*
How to manipulate the Office XML file formats
*
A thorough explanation of RibbonX
*
Best practices for managing external data and using OLAP data sources
*
Methods for effectively debugging your application
*
Tips for packaging and distributing customized applications to other users
Who is this book for?
This book is for Excel users and programmers from beginning to advanced. You should have a reasonable working knowledge of Excel and a full installation of the software.
Wrox Programmer's References are designed to give the experienced developer straight facts on a new technology, without hype or unnecessary explanations. They deliver hard information with plenty of practical examples to help you apply new tools to your development projects today.
Synopsis
Get ready to take your Excel applications to the next level by harnessing the power of the VBA language. This comprehensive resource will help you gain more control over your spreadsheets by using VBA while also showing you how to develop more dynamic Excel applications for other users. From introductory concepts to advanced developer topics, it guides you through every aspect of Excel 2007, including the Ribbon and the XML file formats.
Welche anderen Artikel kaufen Kunden, nachdem sie diesen Artikel angesehen haben?
In diesem Buch
(Mehr dazu)
Buchdeckel | Copyright | Inhaltsverzeichnis | Auszug | Stichwortverzeichnis | Rückseite
Mehr entdecken
Wortanzeiger
Ausgewählte Seiten ansehenWortanzeiger
Buchdeckel | Copyright | Inhaltsverzeichnis | Auszug | Stichwortverzeichnis | Rückseite
Tags, die Kunden mit diesem Produkt verbinden(Was ist das?)Klicken Sie zum Suchen verwandter Artikel, Diskussionen oder Personen auf ein Tag.
|
Kundenrezensionen
Die hilfreichsten Kundenrezensionen
Format:Taschenbuch
I dearly recommend this book to any serious Excel VBA developer. It delivers lots of great ideas and tricks to know, e.g. how to store config information within a worksheet, or working with names and named ranges. Also I liked the appendix for its comprehensive object model listings. It is feels good to have this book sitting on your desk, being able to refer to whenever you get stuck with how a problem solution might look like.
0 von 1 Kunden fanden die folgende Rezension hilfreich
Format:Taschenbuch
Das Englsich ist leicht verständlich und das Buch gut strukturiert aufgebaut.
Im Vergleich zu anderen Büchern, finde ich hier oftmals eine Lösung oder zumindest einen Ansatz zur Lösung. Leider funktioniert nicht jeder Code bei mir, aber damit muss man halt leben. Hier und da könnte auch mehr in die Tiefe gegangen werden, aber das würde wohl den Rahmen sprengen. Von mir eine Empfehlung, wenn man mehr als Formeln in der Oberfläche benützen will und es nicht gleich eine eigene Applikation sein soll :-)
Viel Spaß damit
Antoine
Im Vergleich zu anderen Büchern, finde ich hier oftmals eine Lösung oder zumindest einen Ansatz zur Lösung. Leider funktioniert nicht jeder Code bei mir, aber damit muss man halt leben. Hier und da könnte auch mehr in die Tiefe gegangen werden, aber das würde wohl den Rahmen sprengen. Von mir eine Empfehlung, wenn man mehr als Formeln in der Oberfläche benützen will und es nicht gleich eine eigene Applikation sein soll :-)
Viel Spaß damit
Antoine
Die hilfreichsten Kundenrezensionen auf Amazon.com (beta)
Amazon.com:
9 Rezensionen
29 von 33 Kunden fanden die folgende Rezension hilfreich
It's called a Programmer's Reference, but it's not
20. August 2009
Format:Taschenbuch
Programming books usually take one of three approaches. It either assumes you know absolutely nothing and gives you a very exhaustive history of not only the subject at hand, but programming in general. Or, the book is written "cookbook" style. Finally, some programming books are written as reference books.
This book claims to be a reference book, but it's not. As someone who's programmed for over a decade in a ton of languages and just had to learn enough to get this project done, I wanted a reference book so that I could say, "how do you write an 'if' statement?" "What's the syntax for logical operators in this language?" Stuff like that. You will find *none* of that in this book's index or table of contents.
For example, I had to write a simply if block. if ((condition A) and (condition B) Then 'Do something
I didn't know if the "and" was supposed to be && or AND or something else. So I looked up "logical operators" in the index. Nothing. So I then looked up just "operators". Nothing! Google to the rescue!
I needed to know how to increment a variable. In many languages (Perl, C/C++, PHP), if you have a variable named x, incrementing it would be as simple as x++. I may be wrong, but it doesn't appear that can be done in VBA and you'd have to do x = x + 1. It would be nice if there was a section quickly explaining this stuff.
There are a TON of examples such as this. For example, the books talks about functions. None of the examples, however, show you how to return a value from a function. The syntax is different than in most other languages, so it should at least be given a small mention. Again, google to the rescue!
In some cases, although you can't find it in the table of contents or the index, it *is* in the book. Of course, this then forces you to just aimlessly search from page to page trying to find what you need. For this project I'm doing, because I know nothing of this new language every page teaches me something I didn't know. So I found myself putting post it notes on pages. "Well, I'll need this bit of information to finish this project so let me just bookmark it. Right now, however, I'm looking for X and I still can't find that."
Listen, there is information in there and if you know nothing of VBA, you'll get something from this book (the only reason why I didn't give it 1 star). However, I bought it specifically because it said it was a reference. When I want to know the answer to something, I want a concise, quick way to look up how to do it so that I can move on. Unix Powertools is the PERFECT example of such a book and is probably the best cross-referenced book I ever read. In the end, I should have just saved my money and used google. I'll be returning this book.
This book claims to be a reference book, but it's not. As someone who's programmed for over a decade in a ton of languages and just had to learn enough to get this project done, I wanted a reference book so that I could say, "how do you write an 'if' statement?" "What's the syntax for logical operators in this language?" Stuff like that. You will find *none* of that in this book's index or table of contents.
For example, I had to write a simply if block. if ((condition A) and (condition B) Then 'Do something
I didn't know if the "and" was supposed to be && or AND or something else. So I looked up "logical operators" in the index. Nothing. So I then looked up just "operators". Nothing! Google to the rescue!
I needed to know how to increment a variable. In many languages (Perl, C/C++, PHP), if you have a variable named x, incrementing it would be as simple as x++. I may be wrong, but it doesn't appear that can be done in VBA and you'd have to do x = x + 1. It would be nice if there was a section quickly explaining this stuff.
There are a TON of examples such as this. For example, the books talks about functions. None of the examples, however, show you how to return a value from a function. The syntax is different than in most other languages, so it should at least be given a small mention. Again, google to the rescue!
In some cases, although you can't find it in the table of contents or the index, it *is* in the book. Of course, this then forces you to just aimlessly search from page to page trying to find what you need. For this project I'm doing, because I know nothing of this new language every page teaches me something I didn't know. So I found myself putting post it notes on pages. "Well, I'll need this bit of information to finish this project so let me just bookmark it. Right now, however, I'm looking for X and I still can't find that."
Listen, there is information in there and if you know nothing of VBA, you'll get something from this book (the only reason why I didn't give it 1 star). However, I bought it specifically because it said it was a reference. When I want to know the answer to something, I want a concise, quick way to look up how to do it so that I can move on. Unix Powertools is the PERFECT example of such a book and is probably the best cross-referenced book I ever read. In the end, I should have just saved my money and used google. I'll be returning this book.
7 von 7 Kunden fanden die folgende Rezension hilfreich
Perfect for the impatient programmer who needs to pick up Excel VBA
1. Januar 2009
Format:Taschenbuch
This is the best book I've found to quickly learn Excel VBA. I am an experienced programmer but I had no knowledge of VBA before reading this book. The book gives instant gratification with useful samples that are easily adapted. It teaches by example and still manages to get general and useful techniques across. In short, for my purpose (quickly picking up Excel VBA without getting terribly bored), this book is perfect.
11 von 15 Kunden fanden die folgende Rezension hilfreich
Required Reference for Excel 2007 VBA
7. September 2007
Format:Taschenbuch
The brief treatment of VBA syntax and the power of VBA make this text for intermediate users and above in my opinion.
Its broad scope, covering command bars, class modules, ribbonx, open XML and much more make it a source to be mined over time. As a reader's knowledge increases, he is likely to find first one and then another Excel feature that can be utilized using techniques described in this text.
Its broad scope, covering command bars, class modules, ribbonx, open XML and much more make it a source to be mined over time. As a reader's knowledge increases, he is likely to find first one and then another Excel feature that can be utilized using techniques described in this text.
Waren diese Rezensionen hilfreich?
Wir wollen von Ihnen hören.
Kunden diskutieren
|
Das Forum zu diesem Produkt
Fragen stellen, Meinungen austauschen, Einblicke gewinnen Aktive Diskussionen in ähnlichen Foren
Kundendiskussionen durchsuchen
|
Ähnliche Foren
|
||||||||||||||||||||||||||||||||||
Lieblingslisten
|
|
Ähnliche Artikel finden
Anhand des Sachgebietes nach ähnlichen Produkten suchen:
Ihr Kommentar
Möchten Sie die Produktinformationen aktualisieren oder Feedback zu den Produktabbildungen geben?
|
